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.
 
Info
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
 
Notes
D(Days) will be used as the default unit if no unit is specified.
Notes
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)

Notes
Please ensure the end_date is greater than the start_date.
Notes
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

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

        • Recent Topics

        • Convert Number into Ordinal

          Hello Developers, Here is the solution for converting the Number into Ordinal. For Example: This Idea can be used when lets say you are creating the Dashboard where you are showing upcoming celebrations like work Anniversary for you HRMS Application.
        • Closing the Loop: Why Lookup Asymmetry is Harming Data Integrity in Creator

          TL;DR: Lookup fields allow users to add new related records inline via the "+" icon, but there's no equivalent ability to edit an existing related record without navigating away and losing form context. Adding a native "Edit" icon—with automatic User
        • "Allow New Entries" button for lookup field enhancement

          Hi, When using the "Allow New Entries" option for a lookup field it is sometimes necessary to default certain fields in the related form based on field values in the current form. Would it be possible to add an option to set field values in the Field Properties of the lookup when "Allow New Entries" is selected? This would insure data integrity. Thanks, Damien Cregan Hire an Expert
        • How to merge duplicate products?

          merge duplicate products
        • Email-Data Synchronization with Zoho Analytics

          Hello everyone, Thanks to Chad and everyone who shared their feedback. We're excited to announce support for email data synchronization with Zoho Analytics. We have been working hard to bring this highly requested feature to life, and we'd like to walk
        • Feature Request: Soft validation – Alert with Continue/Cancel on form submission

          I'd like to propose a soft validation option for Zoho Creator forms. This would be an alert on submission that the user can either continue past or cancel. Today the alert can only cancel. The request has come up in the community for over 15 years (What
        • Customer portal: recommended way to scope lookup fields to the logged-in client?

          Hi all, I'm building a customer portal on Creator for our clients (we're a esting lab, so each client has their own sites, contacts and jobs). Planning stage, so I'd rather get the approach right before I build it. The portal forms need several lookup
        • Attachment icon on Meetings and Calls

          Hi all One of these meetings has an attachment on it....but which one? Who knows...... Can I ask that if there is an attachment on a meeting, on the Closed Activities it shows an attachment icon? Would make it easier to know we haven't missed something.
        • more native app support for linux

          Dear zoho,pls build additional apps like zoho valt,zoho sheets,zoho show,zoho authenticator apps for linux ,because more and more people are increasing switching to linux this days,
        • Kaizen #229: Email-Deal Associations in Zoho CRM

          Hi All, Welcome back to another week of Kaizen! Emails are a core channel for customer communication in any CRM system. In Zoho CRM, emails can be associated with records across multiple modules. In this post, we will focus on email associations with
        • This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

          Hello, Just signed up to ZOHO on a friend's recommendation. Got the TXT part (verified my domain), but whenever I try to add ANY user, I get the error: This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details I have emailed as well and writing here as well because when I searched, I saw many people faced the same issue and instead of email, they got a faster response here. My domain is: raisingreaderspk . com Hope this can be resolved.  Thank you
        • SalesInbox attach e-mail to deal

          Hello, I have setup and started using the SalesInbox feature in Zoho.  I could not figure how to attach an e-mail to a deal in the SalesInbox. Our company is dealing with a lot of partners, and I will for example receive in the same day 5 e-mails from the same contacts but that should be associated with 5 different deals, how would I go about that? At the moment, it seems that the only solution is to use the Outlook Plugin in Outlook to attach those e-mails. 
        • Problem with currency field in Zoho CRM

          Hi Guys Zoho Books has a feature in currency fields that automatically converts decimal numbers with commas ( , ) to period format ( . ) when pasting them. For example: R$ 2,50 --> R$ 2.50 Is this behavior available in Zoho CRM? I couldn't find any configuration
        • Email-Data Synchronization with Zoho Analytics

          Hello, Enterprise Support Community! We're excited to announce the availability of Email Data Synchronization with Zoho Analytics! This highly requested enhancement allows you to sync email data from Zoho CRM into Zoho Analytics, making it easier to analyze
        • Action Required: Allowlist New IP Ranges for the EU Data Center

          Dear Users, We are adding new IP ranges for the Zoho Analytics EU data center (https://analytics.zoho.eu). These ranges will come into effect in the last week of December 2026. If you connect Zoho Analytics to cloud databases (both Live Connect and Import),
        • Workflows failing / fields not updating by function or action

          Any one else having issues like this? All was working fine last week, now all of a sudden the system doesn't like 3 fields in one of my (most important) forms, and won't update these by workflow / deluge / action. Only by manually editing, or bulk edits.
        • Mass Update Option for Changing Work Order Owner

          Hello FSM Team/Mr. Abid, We would like to inquire if there is an option to mass update or bulk change the Owner of Work Orders in Zoho FSM. Current Situation: At the moment, the Owner of a Work Order can only be changed individually, which becomes time-consuming
        • Zoho Projects - Auto Populate Project on Project Invoices

          Hi Projects team, I noticed that when creating an invoice from a Project in Zoho Projects, the project is not selected on the invoice. Is this something which you would consider as a feature request? It seems silly that when you create an invoice from
        • Cloud to cloud folder migration from Sharepoint to Workdrive

          I am aware of OneDrive migration: https://help.zoho.com/portal/en/kb/workdrive/migrations/microsoft/articles/migrate-from-onedrive-to-zoho-workdrive#Whats_migrated would this cover a Sharepoint migration meaning I can move a whole Sharepoint (team) folder
        • DYK 16: Set Approval Rules for Timesheet

          Did you know you can decide who approves timesheets based on criteria? Yes, enable Time log or Timesheet approval from Set up to create approval rules that govern their approval processes. Approval rules for Time logs and Timesheet help avoid errors in
        • WhatsApp Business Calling API

          Dear Zoho SalesIQ Team, I would like to request a feature that allows users to call WhatsApp numbers directly via Zoho SalesIQ. This integration would enable sending and receiving calls to and from WhatsApp numbers over the internet, without the need
        • Europäische Zeichen: Komma "," anstatt Punkt "." möglich?

          In alle Betragsfelder müssen wir mit dem Punkt "." die Beträge erfassen wie 123.34 EUR. Das müssen wir nur in Zoho so machen, weil in anderen Applikationen wird in "Europa" mit dem Komma 123,34 EUR gearbeitet. Das Datumsformat kann kann in Books eingestellt
        • Introducing Seek Profile & Seek Ad Sync in Zoho Recruit

          Hiring on SEEK usually means working in two places. You check a candidate's SEEK Profile in one tab to confirm their work history and credentials, then switch back to Zoho Recruit to move them forward. When you post a new role, you rebuild the ad for
        • Zoho Bookings 1.0 is being retired – Switch to Bookings 2.0 by December 2, 2026

          Hello everyone! Zoho Bookings 2.0 was launched on April 17, 2025, introducing a simpler, workspace-based interface for managing appointments and scheduling activities. As part of the transition to the new version, Zoho Bookings 1.0 is being retired. If
        • [Webinar] AI-powered writing and automation in Zoho Writer

          Live webinar on November 12, 2026 | Time: 2 PM IST | 2 PM EST Hi, When organizations create documents, they often start from scratch. Then they need to proofread and translate them. Doing all of this manually takes time, and errors and hard-to-read writing
        • Feature Request - Ability to Customise Contact Info Card on Ticket Details View

          Hi Desk Team, I've added a "Contact Priority" and "Account Prioirty" field and it would be very useful to agents if they could see that information in the Contact Info card on the Ticket Details view. It would be great if we could choose some fields to
        • ChatGPT Plugin / MCP Server auth error

          Hi all I'm trying to connect the ChatGPT plugin for Zoho CRM but after username stage of the auth process, I get this error from the URL https://mcp.zoho.eu/mcp-client/ {"error_description":"Invalid request url, Request is not as per defined in oauth
        • Criteria-based follow-ups , and additional email response signals in Cadences

          Hello all, We've got a couple of updates for Cadences. Until now, the next follow-up in a Cadence was triggered based on the response to the previous follow-up. With this update, when the previous step is a call or a task, you can now also trigger the
        • Introducing Vibe in CRM: Turn Your Ideas to Live Experience

          Hello Partners! AI is changing the way we work and build things every day. Everyone is using AI to build widgets and front-end apps, turning their ideas and requirements into working experiences faster than ever. Imagine simply describing what you want
        • Can Zoho CRM Emails be used in Zoho Analytics in any capacity?

          We're wanting to display details about Lead Activity in regular reports through Zoho Analytics but we're having difficulty integrating Emails at all. We'd like to be able to note when an email is received and when it is sent somewhere other than just
        • Show discounted amount on sales order / invoice against MRP when using Price List

          Zoho has this great feature of having different Price Lists. The only thing missing perhaps is that MRP isn't shown when a price list is selected and discounted amount isn't shown on Sales Order / Invoice. This simple feature could be a great tool for
        • Title: How Are You Managing Sales Order Stock Allocation, Backorders, and Purchase Orders for Multiple Sales Orders in Zoho Inventory?

          Title: How Are You Managing Sales Order Stock Allocation, Backorders, and Purchase Orders for Multiple Sales Orders in Zoho Inventory? Hi Zoho Community, We are using Zoho Inventory under our Zoho One subscription, and we are facing challenges with managing
        • Zoho CRM mobile updates: Display field settings, query support for kiosks, quick navigation button, and more

          Hello everyone, We've made a few updates to the Zoho CRM mobile app to enhance your mobile CRM experience and efficiency. Here's a quick look at what's new: Display field customization (Android) Query support in Kiosk (Android) Quick navigation button
        • Zoho Inventory – Stock Allocation and Warehouse ManagementAs we implement Zoho One in our organization, we are currently facing a challenge with stock allocation and warehouse management. While the wa

          As we implement Zoho One in our organization, we are currently facing a challenge with stock allocation and warehouse management. While the warehouse management part can be handled in Zoho Inventory, our main requirement is the customer-wise stock allocation
        • Zoho Desk MCP doesn't expose all functions

          Hello, I'd like to be able to draft (rather than send) ticket replies using Claude Cowork. However, the Zoho Desk MCP doesn't currently offer that, despite it being available in the API (https://desk.zoho.com/DeskAPIDocument#Threads#Threads_DraftEmailReply).
        • Total Outstanding via Whatsapp?

          Is there a way to Send an automated WhatsApp message to all the customers (for whom outstanding is above 0) on daily basis from Zoho Books directly??
        • Important update regarding public wikis

          Hello everyone, We would like to share an important update regarding public access to wikis created under the Zoho Wiki Free plan. Public access was initially available as part of the Zoho Wiki Free plan. Over time, to improve and optimize our services,
        • 【開催報告】大阪 Zoho ユーザー交流会 2026 NEXUS|少人数でマーケティング・営業を回すZoho×AI活用

          Zoho ユーザーの皆さん、こんにちは。 ゾーホージャパンの中野です。 11月12日(木)、AP大阪にて「大阪 Zoho ユーザー交流会 2026 NEXUS」を開催しました。 今回は、ZohoとAIを活用して、少人数でもマーケティング・営業・顧客対応を回していくための実践例を中心にご紹介しました。 ご登壇いただいた小園さん、アダルシさん、そしてご参加いただいた皆さん、ありがとうございました! ユーザー活用事例 聞き直さない、追いかけない、思い出さない 〜ZohoとAIで一人営業を回す方法〜 登壇者:株式会社ジーニアスウェブ
        • Hiding old CRM Contacts in Desk

          I have an issue with contacts in Desk.   We sync contacts from CRM with DESK and we have old contacts, eg staff members that have left businesses.  The issue is when adding a ticket (most of our tickets are raised over the phone), staff sometimes pick
        • Action Request - Zia Agents - Get Agent API

          It would be great if there was a "Fetch Agent" action for Zia Agents. The main use case here is getting the latest version of the Agent to populate the "Trigger Agent Execution" action. That action requires one to specify which version of the Agent is
        • Next Page