Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Convert date to a number

Topic Labels: Formulas
2994 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Shama_Arige
4 - Data Explorer
4 - Data Explorer

I have a date and a turnaround time. Need to calculate start date = date - turnaround time.
The problem is date is date format and turnaround time is a number like 28. Is there any way to convert a date to a number?

4 Replies 4

DATEADD({date field}, -{turnaround time field}, 'days')

Getting an error unfortunately. is the way to convert the date to a number first?

You don’t need to, unless I’ve misunderstood what you’re tying to do. DATEADD() is function that lets you generate a date based on a start date (in your case, an end date) and a number of days/weeks/months/etc.

What formula did you type in? Did you replace the words between the {brackets} with the actual names of your fields?

Works here.

00%20PM

06%20PM