How to make this a numeric formula instead of duration

Question

Hello,
How can I make this a numeric formula instead  of a duration? 
Min([Weekending Date]-[Employee - Departure / Check out],7)
[Weekending Date]-[Employee - Departure / Check out} are both date fields 
I want to show which ever is shorter in a numeric format. If I use days(7) I can get a duration of 7 days but I need to be able to add or subtract and multiply by this answer in other cells.

Thanks, 
Tara------------------------------Tara Stroup------------------------------

MarkShnierYou · Answer

try thisMin(ToDays([Weekending Date]-[Employee - Departure / Check out]),7)The bold part calculates the Duration, and then the ToDays function converts that span of time into a numeric number of days.  So you will need to change the field type now to formula numeric.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community