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

                                                  • 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


                                                  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 CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • 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


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

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

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • Cannot use a Zoho Form in CRM Email Template

                                                                                                    I've created a Zoho form that has integration with Zoho CRM and is linked to a custom module. I know the form works as I have tested it. When I try and insert this Zoho Form in a button on a CRM email template set up with the same custom module I get
                                                                                                  • Terms & Conditions Templates

                                                                                                    We are using Zoho books for more than 5 years now, We have different Products/Services which has different Terms & Conditions. I suggest to add the possibility to save Terms & Conditions text templates which we can choose during creating invoice or quote.
                                                                                                  • Zoho Recruit - Blueprint and ZIA

                                                                                                    If I activate the Blueprint for Jobs in Zoho Recruit, Zia disappears for matching canddiates, why is that?
                                                                                                  • Mapping for date field from one module to another.

                                                                                                    Hi there, I want to be able to map a date field(due date) in a module (sales order) to another module's(Purchase Requisition) date field(Promised customer date). Is this possible when the due date field is a zoho system date field while the promised customer
                                                                                                  • PDF API FROM ZOHO CREATOR DELUGE SCRIPT

                                                                                                    Hi I am in need of using a PDF Api to compress and Merge PDF files from zoho creator. Any support on this would be really helpfull any sample code for any PDF API would be extremely heplfull
                                                                                                  • Create deal from estimate

                                                                                                    Hello, I have integrated CRM and books. I created an estimate on CRM but I would like to allocate that estimate to a deal with the contact. How can I do this please?
                                                                                                  • Execution failure when fetching a Name field from another app

                                                                                                    In creator I have one app [Employee Directory] with a form [Employees]. One of the fields is a name field called [Name]. Here is a sample that works, if executed from the Employees app: test_Employee = Employees[Name.first_name == "Alex"]; info test_Employee.Name;
                                                                                                  • Auto-Create OneDrive Folder Structure Upon Lead Creation

                                                                                                    Hello, New to Zoho and looking for help on a critical process automation I'm looking to implement. My company currently utilizes OneDrive for file management and the folder structure is Proposals -> Client Name -> Address (where I need to initially create
                                                                                                  • Automatically add user on customer portal

                                                                                                    Hi Guys, I have a doubt about how to automatically add user details to the customer portal. Once the user details are submitted through the user form, those details should be automatically updated in the customer portal. how to do that any one have idea
                                                                                                  • Lookup field, odd issue

                                                                                                    So I tried creating and app that has the names of engineers so I can use that for a lookup in the other apps that are being created . I add the look up in a new app, launch the app and when I try to fill out the form its just blank in the drop down menu
                                                                                                  • Zoholics is weer terug in 2025! Save the date!

                                                                                                    Handen omhoog voor wie Zoholics vorig jaar heeft gemist! Wij ook! Als u nog nooit bij Zoholics bent geweest, leggen we het hier uit zodat u deze kans niet mist. We zijn blij u te kunnen vertellen dat de plannen voor de grote terugkeer van Zoholics in
                                                                                                  • Ticket sends email to 2 different email addresses

                                                                                                    Good afternoon, I am attempting to setup our ticketing system so that when a ticket is created, updated, and closed, it will email both the customer receiving support as well as the salesperson that is associated with the customer. The way that our tickets
                                                                                                  • ZOho Vault access denied

                                                                                                    Hello Community, I have suddenly got restricted by accessing Zoho vault . How can I get access back ?
                                                                                                  • Telephony External ID field added in CRM

                                                                                                    Dear All, We have an enhancement for users with telephony integrations—introducing the Telephony External ID field. Let's get into the details! What is an external ID field for telephony? External ID fields in Zoho CRM essentially hold a record's reference
                                                                                                  • 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. 
                                                                                                  • Shared subfolders

                                                                                                    Am I right in thinking that there is no Zoho email application that allows me to create a shared inbox and then add additional folders/subfolders under that inbox? If so, this is really quite incredible and probably a deal breaker for us to start using
                                                                                                  • Incoming call logging in Bigin

                                                                                                    Request support on how can we log calls on bigin which are incoming. This is one of the very critical requirements for us
                                                                                                  • SMTP Authentication error with django backend

                                                                                                    Hello I have e zoho mail id info@mindbrewers.in But when i use it for smtp it gives 535 authentication error in django website . EMAIL_USE_SSL = False EMAIL_USE_TLS = True EMAIL_HOST = "smtp.zoho.com" EMAIL_PORT = 587 EMAIL_HOST_USER = "info@mindbrewers.in"
                                                                                                  • Important Update: Mandatory Email Domain Verification for Zoho Analytics Users

                                                                                                    To enhance the security and reliability of email notifications, we are implementing an important update. Starting February 1, 2025, verifying your email domain will be mandatory to continue sending email notifications via Zoho Analytics. Failure to verify
                                                                                                  • Insufficient "previlleges" to perform this operation? All of a sudden

                                                                                                    Trying to create a ticket report in the free version of Zoho Desk (Analytics > tickets by contact), same as I have always done for the past 4 years every 2 weeks, and I am receiving the following message: I am labeled as Support Administrator, and we
                                                                                                  • Custom Fonts in Zoho CRM Template Builder

                                                                                                    Hi, I am currently creating a new template for our quotes using the Zoho CRM template builder. However, I noticed that there is no option to add custom fonts to the template builder. It would greatly enhance the flexibility and branding capabilities if
                                                                                                  • Power of Automation :: Trigger Automatic reminders to the task owners five days before the due date.

                                                                                                    Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:-
                                                                                                  • Weekly Tips: Flags for an organized mailbox

                                                                                                    Wishing you all a Happy New Year 🎉 As we step into 2025, it's time to refocus and set our intentions for the year straight. Whether you're already back at work or just returning from the holidays, you probably have emails that need your immediate attention,
                                                                                                  • Cleanest way to change billing method after an invoice has been created?

                                                                                                    Hello, I've added a task with a different rate/hour to a project but cannot change the billing method. I get the following error method: An invoice has been created for this project. Hence, the billing method for the project cannot be changed. Do I have
                                                                                                  • Weekly Tips: Enhance Productivity with Quick Access

                                                                                                    Having thousands of emails, tasks, attachments, and reminders in a single inbox can make navigating to a specific option difficult, especially when you're in a hurry to get things done without putting in too much effort or thought. Whether you need to
                                                                                                  • Language Field on Contact Person-level

                                                                                                    Dear at Zoho Books, would it be possible for you to have a Field for 'Language' for the Contact Persons under a Company. In CRM and Bigin we could create a Custom Field (Dropdown) for this effect but without any present in Zoho Books we could never sync
                                                                                                  • CRM - Copy data from Single Line to Lookup Field

                                                                                                    Hello, I need help to create a workflow with a custom function in order to copy value from a single value field to a Lookup Field. Module : Shipment Single value field API name : Customer_ID Lookup field API name : Account_ID WOuld be great to have some
                                                                                                  • Support for Developing Zoho Recruit Extensions via Zoho Sigma

                                                                                                    Hi, I’m interested in building an extension for Zoho Recruit using Zoho Sigma. However, when I navigate to Sigma and attempt to create a new extension (via the "New Extension" option), Zoho Recruit does not appear as a listed service—only options like
                                                                                                  • Tasks are not visible or clickable anymore

                                                                                                    Hi, We're facing problems with tasks connected to a module. As you can see, if we open for example an account record, all open and closed tasks are not visible anymore (only text 'undefined') and we can not click on those tasks. Do you know what is
                                                                                                  • Payoneer for Zoho

                                                                                                    I have set up a gateway to my Zoho Books i.e. Payoneer for Zoho and connected it successfully with my Payoneer account. Then I created an invoice and sent it foward. But when my customer tries to make a payment, the error screen appears So what can I
                                                                                                  • What's New in Zoho Analytics Mobile BI App - January 2025

                                                                                                    Elevate your on-the-go analytics experience with the latest enhancements in the Zoho Analytics - Mobile BI App. These updates ensure a seamless, visually consistent, and feature-rich experience across mobile devices. Here’s what’s new: Enhanced Chart
                                                                                                  • Directly Edit, Filter, and Sort Subforms on the Details Page

                                                                                                    Hello everyone, As you know, subforms allow you to associate multiple line items with a single record, greatly enhancing your data organization. For example, a sales order subform neatly lists all products, their quantities, amounts, and other relevant
                                                                                                  • Zoho One Backup of entire account

                                                                                                    Hello, When using Zoho one is there a way to backup your entire account of all apps that you are using \ activively using in a single step or do you have to backup each applications data individually? Thanks,
                                                                                                  • Unable to send message;Reason:550 5.4.6 Unusual sending activity detected. Please try after sometime

                                                                                                    Hello i'm unable to send any email because i keep getting this error Unable to send message;Reason:550 5.4.6 Unusual sending activity detected. Please try after sometime i have literally sent less than 10 emails today i'm not sure why i'm getting this
                                                                                                  • Cannot unblock IMAP for my account

                                                                                                    IMAP got block on my account for suspicious activity because I was testing different VPN servers in different locations. When I try to unblock it I get an error that says Sorry , we are unable to process your request, please contact support@zohomail.com.
                                                                                                  • Zoho Team Inbox down for several hours

                                                                                                    Error while processing the request! javax.mail.MessagingException: java.io.IOException: Problem communicating with the recipient server
                                                                                                  • Migration meines Accounts auf einen europäischen Server

                                                                                                    Hallo, wie kann ich meine Daten auf einen europäischen Server migrieren lassen? Ich habe hauptsächlich mit Kunden in Deutschland zu tun, die einen entsprechenden Datenschutz erfordern. VG, Kai
                                                                                                  • Restrict Payment Methods

                                                                                                    Allow us to restrict certain payment methods specific for each customer.
                                                                                                  • CHange timeformat in Tasks from 12 to 24 notation. Is that possible?

                                                                                                    Hi, I'm in the middel of the proces to possible migrate from Office365 tot ZOho. There are still some questions. One of them: How can I change the timeformat from 12 hour to 24 hour format? I can change it in my calendar settings, but it doesn't change
                                                                                                  • Ability to use Rules to automatically "Exclude" transactions from Credit Card/Bank Statements

                                                                                                    Currently there is only the option to Categorize transactions based on rules, this request is to add "Exclude" to the rules so they could be automatically ignored based on the criteria.
                                                                                                  • Next Page