Easily perform calculations using dates with the new DATEDIF function
Hey Zoho Writer users!
We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years.
Function syntax:
=DATEDIF(start_date, end_date, unit)
Inputs:
start_date
| The date from which the calculation begins
|
end_date
| The date till which the calculation is needed
|
unit
| The format (day, month, year) in which the difference should be calculated.
|
You can also have the start_date and end_date as a merge field or an auto-date field.
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
|
D(Days) will be used as the default unit if no unit is specified.
DATEDIF returns the difference as an integer.
How to insert a DATEDIF function in Zoho Writer:
- Click the hamburger menu located on the top left side of the editor and click Fields.
- Click Formula located under the Dynamic Fields category.
- In the popup, click Choose Function and choose DATEDIF from the list of functions.
Here are some examples of the DATEDIF function:
Example
| Syntax
| Output
|
Calculate the difference between Dec. 28, 2023 and Feb. 28, 2024 in months
| =DATEDIF([28/12/2023], [28/02/2024],"M")
| 2
|
Calculate the difference between Jan. 15, 2024 and March 16, 2024 in days, excluding months and years
| =DATEDIF([15/01/2024], [16/03/2024],"MD")
| 1 (Because the difference is 1 day and 2 months, this formula returns 1 day)
|
Calculate the difference between Feb. 20, 2023 and April 20, 2024 in months excluding years
| =DATEDIF([20/02/2023], [22/04/2024],"YM")
| 2 (Because the difference is 1 year and 2 months, this formula returns 2 months)
|
Please ensure the end_date is greater than the start_date.
To use the DATEDIF function in Writer's merge templates please make sure the field type is date and configured in a date format supported in Zoho Writer.
A real-world example:
Let's say you're sending reminder emails to your event attendees mentioning the number of days until the event. The DATEDIF function allows you to easily insert this number without doing the calculations manually.
Try the new DATEDIF function in Zoho Writer and let us know your suggestions and feedback in the comments section below or email us at support@zohowriter.com or support@eu.zohowriter.com.
If you have any function that you want us to add in Zoho Writer, please let us know in the comments.
Regards,
Team Writer
Sticky Posts
Introducing group by, aggregation, and repeating regions in mail merge templates
Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates. We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now
Say hello to an improved way to merge documents!
Automating all your documents from start to finish is now easier than ever with Writer's new merge tools. If you haven't seen it yet, you can read the main announcement here. Here is the full list of the features we've rolled out: 1. Dynamic Table Headers
Introducing Org Fonts in Zoho Writer
Hey Zoho Writer users! We're excited to share that you can now add custom fonts (from web fonts with publicly accessible URLs) using Zoho Writer's Org Fonts. This option allows all users across your organization to use the custom font without the hassle
Easily perform calculations using dates with the new DATEDIF function
Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:
Zoho Writer's WordPress extensions
Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window