How to use DATEDIF formula in Zoho Writer

How to use DATEDIF formula in Zoho Writer

Overview 

The DATEDIF function in Zoho Writer allows you to calculate the difference in days, months, or years between two dates. You can insert the DATEDIF function in paragraphs, tables, and merge and fillable templates in Zoho Writer.

Syntax 

=DATEDIF([start_date], [end_date], "unit")
Inputs
Parameter
Description
start_date
The starting date from which the calculation begins. This can be a merge field, or an auto-date field (dynamic today's date or a current date).
end_date
The date up to which the calculation has to be performed. Similar to the start_date, it can be a merge field or an auto date field.
unit (optional)
Specifies the unit (years, months, days, etc.) in which the difference is calculated. If no unit is provided, the default value will be "D" (days).

Supported Units
Unit
Description
"Y"
Calculates the difference in years.
"M"
Calculates the difference in months.
"D"
Calculates the difference in days (default if no unit is specified).
"MD"
Calculates the difference in days, excluding years and months.
"YM"
Calculates the difference in months, excluding years.
"YD"
Calculates the difference in days, excluding years.

Steps 

  1. Go to the Fields tab --> Formula.
  2. In the New Formula dialog that opens:
    1. Choose the DATEDIF function from the Choose Function drop down and the + icon to select the fields, to configure the desired formula.
    2. Choose the Format Number option to format the formula result.
    3. Click Insert. 

Note 

  1. D(Days) will be used as the default unit if no unit is specified.
  2. DATEDIF formula returns the difference as an integer.
  3. You can have the start_date and end_date as a merge field or an auto-date field.
Using formulas in Zoho Writer
List of formulas supported in Zoho Writer
How to format formula's output
How to refer formula's output across document
How to use circular reference in formulas