Easily perform calculations using dates with the new DATEDIF function

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:
 
  1. Click the hamburger menu located on the top left side of the editor and click Fields.
  2. Click Formula located under the Dynamic Fields category.
  3. 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


    Access your files securely from anywhere

        Zoho Developer Community







                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation
                                              • Sticky Posts

                                              • Date-based conditions and filters

                                                Configure conditions with date  Hi everyone! We are excited to announce that you can now compare and filter data with date-based conditions. This update lets you compare date fields in a document to a reference date and display a text or value if the
                                              • 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:


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns Resources


                                                                          Zoho CRM Resources

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Tips

                                                                            Tips

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now