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

• Topic Participants

• Varadarajan AR

  

• Laura

• Balaji V

  

• 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

• Recent Topics

• we need to add a Customer Number field to the PDF document templates

  Hello everyone. We are currently using Zoho Inventory for our small business operations and have found it to be a valuable tool. However, we’ve encountered a specific requirement: we need to add a Customer Number field to the PDF document templates (such

• Joining Two Reports

  Hello Guys, I have three modules: - Orders - Custom module - Clients - Contacts - Basic Pay I am using the order module to store the revenue share amount for each order which will be paid a sales rep The Orders are child or clients so I am pulling a report

• Power of Automation :: Notify users Automatically when @Mentioned in Tasks Description

  Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate

• Recording a payment in foreign currency not allowed

  Hi, my base currency is CHF. I made an invoice in EUR, which have been paid with an extra amount (which are the fees I guess). When I record that payment from the invoice page, I can select the EUR bank account. But the amount received is above the invoice

• Introducing WhatsApp integration and quick editing capabilities in Zoho Sign

  Hi there, Zoho Sign already helps users collect signatures via email and SMS, and we're happy to announce that you can now send documents and authenticate recipients right through WhatsApp. Some of the key benefits include: Communication with recipients

• Order Wise Expense Tracking and Reporting Possible?

  Hi, We are a manufacturing firm and take up several orders at the same time. Each order will be associated with a single sales order and then once completed to a single invoice. When recording expenses, is it possible to associate each expense with a

• Related Module in Sharing Rules

  Zoho CRM team recently added the feature to filter records by Related Records It will be really beneficial if we can have this feature for Sharing Rules as well

• Zoho Flow Needs to Embrace AI Agent Protocols to Stay Competitive

  Zoho Flow has long been a reliable platform for automating workflows and integrating various applications. However, in the rapidly evolving landscape of AI-driven automation, it risks falling behind competitors like n8n, which are pioneering advancements

• Layout Rule Fields Appear in "Verify Details" Pop-up — Confirmed Working

  Hey everyone — just wanted to share a quick discovery. I created a Layout Rule in the Deals module that makes two fields show up (and required) when the stage is set to Closed Won or Closed Lost — one pick list and one text field. To my surprise, those

• Can you please let us know how we can use Zoho for multi store?

  Hello Team, Can you please let us know how we can use Zoho for multi store because when we connect our plugin to Zoho and we create a product and then on another store when we create product with same name then product already exist error occurs, so how

• Zoho One Home Dashboard - My Tasks (Projects) & My Overdue Work Items (Projects) have no data.

  The title basically covers the situation. I've set up the dashboard cards, and for a while, they were showing data. Now, they are both blank. Is anyone else experiencing this, or has anyone else experienced this, and if so, is there a fix?

• Zakya - Release in North America?

  At Zoholics it was pitched like Zakya was already released in North America. However, when looking for it I couldnt find it. There isnt an integrated app available in Zoho. I figured maybe it was being released at Zoholics. Now over a month later, its

• Custom Field Mapping in Outlook

  I have 10 custom fields in Zoho is there a way to create and map them to the outlook contact?

• Custom module - change from autonumber to name

  I fear I know the answer to this already, but thought I'd ask the question. I created a custom module and instead of having a name as being the primary field, I changed it to an auto-number. I didn't realise that all searches would only show this reference.

• Enhanced Zoho CRM and Office 365 calendar synchronization features!

  Dear customers, We're excited to share some significant improvements to our Office 365 calendar synchronization features, aimed at providing you with more control and a more personalized experience. What’s new Choose your Office 365 calendar: During the

• Problemas de usarmos no Brasil

  Somos usuários a exatamente um ano do Zoho Recruit, agora migramos para o Zoho One. Temos enfrentado por diversas vezes problemas da ferramenta não estar realmente preparada para funcionar corretamente na lingua portuguesa. Problema esse não específico

• CERTIFICADO DIGITAL - BRASIL

  Olá, Temos o ZOHO ONE e no Sign vemos de forma simples a assinatura digital, temos nos BRASIL certificado digital, de no CERTISIGN homologado pelo GOVERNO do BRASIL, há possibilidade de gerar a assinatura diante deste certificado?

• Zoho Duplicate Reference Numbers

  I have 2 accounts through zoho. On one account if I enter a bill with the same number as a previous bill I get a warning message saying that there is already a bill with this number. However on the other account I do not get this message. How do I turn

• integration between Zoho Site and Zoho Learn

  integration between Zoho Site and Zoho Learn so that when a user registers on the Zoho Site, their account is automatically created in Zoho Learn!! the use case i have pro plan in zoho site and zoho learn and i have puted the zoho learn domain in zoho

• Automation #6 - Prevent Re-opening of Closed Tickets

  This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Typically when a customer submits

• Not able to list or add contacts

  I am not able to get a list of contacts via api request. Tickets for example are listed via api even without orgId, so it shoud be similar. What is missing to reach the requirement. My aim ist to add a contact via API and then add a ticket with the contact

• See contrat information from an account under the ticket

  Hi there, How can I program something to display created and selected contract on the ticket itself so my agents see it and can support correctly according to the contract and SLA ? Thank you :)

• Weekly time log view

  The Weekly Time Log view is pretty nice. My users really like it when I show it to them. They like being able to pin ongoing tasks. Anyway, it's sort of hard to find. It is grouped with the Add Time Log button as a pull down. In my opinion, it should

• Any Impact of Amazon Listings API on E-commerce Integration?

  Amazon sent the following message about changes to their APIs. Our only Amazon app / integration is Zoho Inventory's eCommerce for Amazon US, so the message below in bold gives us concerns about if Amazon's warning is referencing Zoho's Amazon US integration.

• Working with Products that are non-tangible

  How does one create a 'service' in products? Is there a way to disable inventory functions for things like Sofware as a service? The services module doesn't look to be much help either. Not sure how to do this in CRM

• ePOD Devices

  Has anyone tried and tested and devices that deliver ePOD (electronic proof of delivery)? We would like our drivers to use an ePOD device to get the customer signature The app should then be capable of updating the sales order to show delivery.

• API Integration

  Why are we unable to do API Integration for Job borads

• Remind/Recall Document API

  When I recall a document through the Sign API, I would like to be able to specify the reason that gets sent in the user notification email. Same with including a unique message when sending a document reminder through the API. Is there a way to include

• Zoho Books API Creating Invoice and Address API

  I'm trying to create an invoice with zoho books api and i get the following error: Error creating invoice in Zoho Books: { message: 'Request failed with status code 400', details: { code: 15, message: 'Please ensure that the "billing_address" has less

• Convert Multiple PO in 1 Bill

  Does anyone know how to convert multiple POs in 1 Bill? Thank you

• merge the Multiple POs to single PO if Vendor of PO"s --in Zoho Inventory

  HI Merge the Multiple POs to single PO if Vendor of PO"s are Same ----in Zoho inventory Please provide any work around to achive this .

• How to add categories to community

  In my Community, I would like to add several Categories but I don't readily see how this is accomplished. Currently, I have one category in my community with several forums. But I would like to add more categories. Thanks.

• Knowledgeable Image Quality is very poor, any recommendations how to improve this?

  Hi All, We are looking at migrating our current knowledge base to Zoho so it can be kept in one location. Our current KB utilises a lot of images to try and make it easier for users and less wordy. Unfortunately, when I upload an image within an article,

• Assistance Required: Displaying Dynamic HTML Table in Zoho Creator Dashboard Page

  I am currently stuck while creating a custom dashboard page in Zoho Creator. I want to display a designed HTML table showing Teacher Registration data with this condition: If Total Allowed Leaves < 10, display those teachers in the table. Page Scripts

• Visibility of Custom Questions in the Question Pool

  A colleague is adding our own questions in the question pool for our Employee Engagement survey, but I can't see the questions she has entered, even after refreshing the webpage. Are the custom questions in the question pool only visible to the one who

• campaigns contact lists not exporting

  I'm trying to export a specific lead source from my contract list in 'campaigns'. Every time I have to do this the contacts won't export. I have done a search and selected the specific contacts I want to export. The box appears to choose the file type,

• Recipient Field on replies doesn't update with Contact change

  Some emails that come into our system come from an online form and the sender address is a noreply@whateverthedomainis.org So in order to reply to the original sender, we need to update/change the contact for the tickets. However, after we change the

• Multicolumns fields for native forms

  It would be nice to be able to create forms with multiple columns. Currently, each field occupies a single column, which makes a fairly complex form seem too long.

• Assign values to hidden fields in native forms

  It would be great to be able to assign values (static or dynamic) to hidden fields in a form. Currently, I can only assign a value via the URL. I currently have a form integrated with a webhook, but I don't have a way to send useful form data as parameters,

• Migrating Email Content to a Shared Mailbox Address

  I am moving my email to Zoho Mail (currently hosted through GoDaddy). I have created a user (me) and I have also created a "Shared Mailbox" Group (through the admin panel) with an email address I will be using as an organization address. My personal email

• Next Page