DAYS() – Calculates the number of days between two dates

DAYS(endDate, startDate)

• endDate: The later date, or a cell reference containing the later date.
• startDate: The earlier date, or a cell reference containing the earlier date.
• Both dates can be entered as text (e.g., "15/01/2025", conforming to your MathGrid date settings) or be the result of other date functions like TODAY().

DAYS(T1A2, T1A1)

Calculates the number of days between the date in cell T1A1 (start date) and the date in cell T1A2 (end date).

Example outputs:

• If T1A1 = "01/01/2025" and T1A2 = "15/01/2025" (assuming "dd/mm/yyyy" format): DAYS(T1A2, T1A1) → 14
• Using text dates directly (assuming "dd/mm/yyyy" format): DAYS("10/03/2024", "01/03/2024") → 9
• Using TODAY() (assuming today is "20/07/2024" and T1B1 is "01/07/2024"): DAYS(TODAY(), T1B1) → 19

• Numeric output: Returns the total number of days as an integer.
• Flexible input: Accepts dates as text strings (matching MathGrid's date format) or as cell references/date function outputs.

• Calculating the duration of projects or tasks.
• Determining the number of days overdue for payments or deadlines.
• Calculating age in days: DAYS(TODAY(), "birth_date_cell").
• Finding the time elapsed between two specific events.

• Incorrect date format: Ensure text dates provided directly to the function match the date format specified in MathGrid's settings.
• Using non-date values: Both arguments must be valid dates. Text that cannot be interpreted as a date will cause an error.