Dynamically calculate the difference between two dates with a DATEDIF function in Zoho Office Integrator

Hi users,

We're pleased to introduce a new formula in Zoho Office Integrator's document editor: DATEDIF. This formula allows you to calculate the difference between two dates in days, months, and years—and eliminate errors due to manual calculations.

DATEDIF function syntax:

=DATEDIF(start_date, end_date, unit)

Inputs:

start_date	The date from which the calculation begins
end_date	The date at which the calculation ends
unit	The format (day, month, year) in which the difference should be calculated.

List of supported units:

Unit	Description
Y	Calculates the difference in years
M	Calculates the difference in months
D	Calculates the difference in days
MD	Calculates the difference in days, excluding months and years
YM	Calculates the difference in months, excluding years
YD	Calculates the difference in days excluding years

Some examples of DATEDIF functions:

Example	Syntax	Output
Calculate the difference between June 12, 2024 and August 28, 2024 in days	=DATEDIF([12/06/2024], [28/08/2024],"D")	77
Calculate the difference between Aug. 28, 2024 and Oct. 30, 2024 in days, excluding months and years	=DATEDIF([28/08/2024], [30/10/2024],"MD")	2 (Because the difference is 2 days and 2 months, this formula returns 1 day)
Calculate the difference between Feb. 20, 2024 and April 20, 2025 in months excluding years	=DATEDIF([20/02/2024], [20/04/2025],"YM")	2 (Because the difference is 1 year and 2 months, this formula returns 2 months)

Note: You can use DATEDIF functions in both documents and merge templates. Learn more about Zoho Office Integrator's Merge APIs.

Real world examples of using DATEDIF functions:

Calculate the difference between a project's start and end date with a DATEDIF function to generate project specific reports.
Calculate how long a client has used your outdoor billboards based on the start and end dates, and generate personalized usage-based invoices.

Want to see how Zoho Office Integrator works? Check out this overview.

Try the new DATEDIF function in Zoho Office Integrator's document editor and let us know your feedback at support@zohoofficeapi.com or support@eu.zohoofficeapi.com or in the comments below.

If you have any functions that you want us to add, let us know in the comments.

Best regards,

The Office Integrator Team