Dashpivot offers a range of date formulas that help you calculate, manage, and analyse date values inside your forms and templates. These formulas are especially useful for:
Scheduling and compliance tracking
Data analysis
Project Timelines
Cut-off dates and payment schedules
Alerts and reminders
Using date formulas in Dashpivot helps streamline your workflows, automate calculations, and make your processes easier to track. Dashpivot formulas follow the same syntax as Microsoft Excel and support most of Excel’s built-in date functions.
Note: Date formulas can only be used inside default tables or prefilled tables.
DATE()
Purpose: Use this to build dates in the DD/MM/YYYY format from dropdowns or number fields. This is helpful when collecting dates as separate inputs (e.g., Y/M/D)
Formula to use: =TEXT(DATE(A1,B1,C1),"YYYY/MM/DD")
Note:
Where the A1, B1, C1 is the cell number. A1 represents the year, B1 is the month, C1 is the day.
TEXT()makes the output match your MM/DD/YYYY field format.
DATEDIF()
Purpose: Calculate the number of full days between two dates.
Formula to use: =DATEDIF(A1,B1)
Notes:
A1 and B1 would be in Date field. The order does not matter, the formula returns the same value.
Ideal for ageing reports, durations, and days since an event
DAY()
Purpose: To extract the day of the month (1–31).
Formula to use: =DAY(A1)
Notes:
A1=Date in date field.
Good for rules or calculations involving specific days of the month.
DAYS()
Purpose: To calculate the difference between two dates using Date2 − Date1.
Formula to use: =DAYS(B1, A1)
Notes:
Order matters as the reverse order produces negative values.
Useful for turnaround times or date comparisons.
DAYS360()
Purpose: Calculate the number of days between two dates using a 360-day calendar.
Formula to use: =DAYS360(A1, B1)
Notes:
Often used for finance-related schedules or consistent month lengths
Format 0 = includes 31st, Format 1 = excludes 31st (optional)
Difference between DAYS() and DAYS360()
Day1 | Day2 | Results | Formula |
12/01/2025 | 01/31/2026 | 60 | =DAYS(Day1,Day2) |
12/01/2025 | 01/31/2026 | 61 | =DAYS360(Day1,Day2) |