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


    Zoho Campaigns Resources

      Zoho Desk Resources

      • Desk Community Learning Series


      • Digest


      • Functions


      • Meetups


      • Kbase


      • Resources


      • Glossary


      • Desk Marketplace


      • MVP Corner


      • Word of the Day


        • Sticky Posts

        • 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:
        • 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

        Zoho CRM Plus Resources

          Zoho Books Resources


            Zoho Subscriptions Resources

              Zoho Projects Resources


                Zoho Sprints Resources


                  Zoho Orchestly Resources


                    Zoho Creator Resources


                      Zoho WorkDrive 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




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • Quais são os maiores desafios que você enfrenta ao implementar o Zoho CRM?

                                  Olá, pessoal da comunidade Zoho Brasil! Sou parceiro autorizado da Zoho e, ao longo do tempo, tenho notado que cada implementação de CRM traz desafios únicos, dependendo do segmento de negócio, das metas da empresa e até da familiaridade da equipe com
                                • Featured Blog Image Size

                                  What is the ideal size for the cover/featured image of a Zoho Sites blog? Because all our cover images are getting these black stripes horizontally or on the sides (look images)
                                • This mobile number has been marked spam. Please contact support.

                                  Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?
                                • Zoho CRM v2.1 deprecation or sunset plans ?

                                  Hi Team Wanted to know if there is any plan to deprecate v2.1 CRM apis https://www.zoho.com/crm/developer/docs/api/v2.1/ and if yes by when
                                • Do I need to migrate to API v7?

                                  Current workload forces me to ask this question. Even though I know API v7 has better features, I have many previous API calls written in v2 that still function well. Is there any compelling reason (that I may be missing) for me to make time to migrate
                                • Has anyone implemented OCR functionality as a text input method for the CRM?

                                  The users in my organisation are used to writing meeting notes using the pen and paper notebook. Asking them to enter those notes into the CRM is a chore and I suspect is a major hurdle for the digitalisation initiative to take off in this organisation.
                                • way to change the interface language (e.g. to English) in the whole Zoho One ecosystem at once

                                  Hi everyone. I had a need to create a new Zoho One account for a new company. However, since I did it from Germany, I have defaulted to German language in Zoho One interface (in all apps). Can you please tell me if there is a way to change the interface
                                • My email id is blocked. My storage is exceeded 5GB. Deleted unwanted emails.

                                  My email id is prem@justbootup.com. I tried to unblock ,but it says only for the paid user. Can you help to unblock?.
                                • How Can I delete accounts or change type of account?

                                  My accountant has wrongly categorized many accounts as Other Assets instead of Accounts receivable while putting in opening balances. How can I delete an account or recategorize it?
                                • How to have sub heads in Salary account

                                  Hi How can i have sub heads under salary account, we tried but it is not allowing us to create sub heads Thanks Alka
                                • Can I give access of my Zoho Spreadsheet?

                                  Hello Everbody! I work with a travel and tourism company, and my job is to record the data of clients of the company. And I use zoho for my work. So my question is can I give access of my sheet to the clients and my company. Kindly guide me. Thankyo
                                • Is it possible to display formulas in cells instead of calculated results?

                                  I want to export my Zoho sheet as tab separated text without losing the formulas. In excel, I would use the settings Options - Advanced - show formulas in cells instead of their calculated results then save as tab separated values. How do I do this in
                                • Zoho Mail Not Receiving or Sending Email

                                  My zoho mail is not sending or receiving mail. What's the fix for this?
                                • Unsuscribe, suscribe and tell a friend links not working

                                  Hello, I'm new to Zoho campaigns. I created and sent a test campaign to myself but on clicking the subscribe, unsubscribe, view in browser ans tell a friend links, i realize none of them leads anywhere. Instead i get the following error:
                                • Tip #5: Setting access rights at the subfolder level

                                  Hello everyone, We hope you're finding our WorkDrive Tips and Tricks series useful. For today's tip, we'll teach you how to assign higher subfolder permissions to Team Folder members. Team Folders helps you avoid the drawbacks of traditional file sharing.
                                • This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

                                  I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the
                                • Cross-Data Center Collaboration and / Or allowing users to choose DC

                                  Dear Zoho Cliq Support Team, We are writing to request a significant enhancement to Zoho Cliq that would greatly benefit our geographically dispersed development team. Current Challenge: Currently, Zoho Cliq automatically routes users to specific data
                                • Getting error for invalid session on zoho mail

                                  Hello, Today our office staff start having challenges with our email once logged in. I keep saying : Invalid session you will be logged out in 3 seconds. And it wont allow me to send any messages.
                                • Login Request

                                  Good afternoon. Id like to receive help, I'm requesting information in regards to account login issues. I've bee asked to provide additional security information. Ie: phone number in order to access my account. I no longer have access to this account
                                • integrating Zoho CRM vendors with Zoho projects

                                  In most of our projects we collaborate with our Vendors. Being able to integrate only Accounts and not Vendors from CRM, is a huge limitation for our perspective and needs. We would really love to see this feature in the CRM-Projects integration.
                                • Allocate emails to user in a shared mailbox

                                  Hi, This might be obvious, but I cannot find the answer. I have 3 shared mailboxes so any team member can see the emails. Is there a way of allocating a specific email to a user so that it is their responsibility to deal with it? Thanks in advance.
                                • Multiple Vendor SKUs

                                  One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for
                                • Include SalesIQ activity when sending Forms data to CRM as a new Lead

                                  Is there a way that when I get a new lead via a zoho form on my website to include the activity in CRM? I have Sales IQ integrated with the form however, most of my leads do not talk to us through the chat fuction but they do fill out a zoho form. Id
                                • Unblock ME

                                  info@pentekykloi.gr Unable to send message;Reason:554 5.1.8 Email Outgoing Blocked. Learn more. I purchase additional storage
                                • Getting error for invalid session on zoho mail

                                  Since yesterday I am getting following error when I am trying to log in on zoho mail your session is invalid. you will be logged out in 3 seconds!!  Can someone please help me how to fix this? Thanks Manoj
                                • Can't add Email Alias - AS101 error

                                  Hi, It won't let me add a alias email address on any of my domains under Admin Console,  User, add alias email address it just says AS101 error, I have never had issues creating an alias address before Please fix this
                                • Reply All function omits the full list of original To and Cc recipients in the email body

                                  When using "Reply All" in Zoho Mail, the email body only shows the sender's details (e.g., "John Doe wrote") without listing the original To and Cc recipients, making it difficult for recipients to see the full email thread context. This differs for example
                                • Attendance Bulk Import Not working.

                                  It was working for me from last one year the same format. but now its giving bad request(400). Please help me. resolved this problem.
                                • ZOho Booking and CRM integration.

                                  We are using Zoho Booking wiht Zoho CRM in a custom module. Inside our module we use the option to book a meeting with the customer. This part works great we feed the field to the URL and everything work 100%. Now my issue is that I was not able to find
                                • Chrome browser issues. Anyone else?

                                  I am suddenly having multiple issues with Chrome browser interpreting the Zoho Mail interface.  Anyone else?  Any known problems? Thanks, Todd
                                • 554 5.2.3 MailPolicy violation Error, help?

                                  This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. 554 5.2.3 MailPolicy violation Error delivering to mailboxes I am not sure why i am getting this, please
                                • Display comma in number field (thousand separator)

                                  Love Zoho so far!  How can I add comma as thousand separator in number field upon input by user?  This is essential feature when dealing with larger numbers to make readable.  Is there number formatting script for this? For example, change 600000 to 600,000 This link appears to be related to the topic. https://help.zoho.com/portal/en/community/topic/amount-display#2266000001410984
                                • Any way to Associate a Recurring Invoice with Deal/Potential in Zoho CRM

                                  When we create an Invoice in Zoho Books, we have the option to associate that invoice with a Potential/Deal that is tied to that same customer. Can we do the same thing with Recurring Invoices? When creating a Recurring Invoice, I want to be able to Associate
                                • Tracking leads through the sales process

                                  Our leads are being generated via paid google ads and are arriving to us with UTM data showing lead sources, campaign mediums and campaign names. I want to track the progress of those leads as they migrate through our sales funnel while maintaining a
                                • Elevating Email Security on Zoho Desk: DKIM Now Mandatory

                                  Hello Zoho Desk Users! It has been a wonderful journey with you on Zoho Desk. As we welcome 2025, we are strengthening our efforts to ensure a secure and seamless experience for you. To enhance email security, DKIM configuration will be mandatory for
                                • How to send mail with js SDK

                                  Hell o I'm using https://live.zwidgets.com/js-sdk/1.2/ZohoEmbededAppSDK.min.js, for my widget in CRM (built with sigma) Is it possible to send email from js file, I try ti use that ZOHO.CRM.API.sendMail({ "Entity": "Accounts", "RecordID": sharedVariableEntityId,
                                • How to merge data from Zoho CRM to Zoho Sheet

                                  Hello! A few months ago, I made a Zoho sheet with the ability to bring in data from Zoho CRM. It worked by adding the email of a Contact to the sheet, and then it would fill in the rest of the information in the row with information that was stored in
                                • Zoho say my domain seems to be already associated with another account

                                  I created a website on zoho and associated my domain (bompescado.com) on it. You can see the A record and CNAME are working to it. Now I need to associate the same domain as webmail, but when I try it return with: " This domain name seems to be already associated with another account. If you own this domain, please contact us for assistance." Im following the advice and conctacting you to say I've not been associated this domain on zoho before.  What do I need? Well, I need you manually remove it
                                • Zoho Sheets working offline

                                  Hi,  I am looking for the ability to work offline in Zoho Sheets, but currently I cannot find the process to complete this.  Does someone have any ideas or steps I might have missed?  Also does Zoho Sheets have the "Format as Tables" function as is currently in MS Excel 2016??  Many thanks. 
                                • Lost ZB Code

                                  Hi,  Please what is the ZB code for my domain? It was mistakenly deleted. Please treat as urgent.  
                                • Next Page