Dynamically calculate the difference between two dates with a DATEDIF function in Zoho Office Integrator

Dynamically calculate the difference between two dates with a DATEDIF function in Zoho Office Integrator

Hi users,
 
We're pleased to introduce a new formula in Zoho Office Integrator's document editor: DATEDIF. This formula allows you to calculate the difference between two dates in days, months, and years—and eliminate errors due to manual calculations.

DATEDIF function syntax: 

=DATEDIF(start_date, end_date, unit)
 
Inputs:

start_date
The date from which the calculation begins
end_date
The date at which the calculation ends
unit
The format (day, month, year) in which the difference should be calculated.
 
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
 

Some examples of DATEDIF functions:

Example
Syntax
Output
Calculate the difference between June 12, 2024 and August 28, 2024 in days
=DATEDIF([12/06/2024], [28/08/2024],"D")
77
Calculate the difference between Aug. 28, 2024 and Oct. 30, 2024 in days, excluding months and years
=DATEDIF([28/08/2024], [30/10/2024],"MD")
2 (Because the difference is 2 days and 2 months, this formula returns 1 day)
Calculate the difference between Feb. 20, 2024 and April 20, 2025 in months excluding years
=DATEDIF([20/02/2024], [20/04/2025],"YM")
2 (Because the difference is 1 year and 2 months, this formula returns 2 months)
 
Note: You can use DATEDIF functions in both documents and merge templates. Learn more about Zoho Office Integrator's Merge APIs. 

Real world examples of using DATEDIF functions: 

  • Calculate the difference between a project's start and end date with a DATEDIF function to generate project specific reports.
  • Calculate how long a client has used your outdoor billboards based on the start and end dates, and generate personalized usage-based invoices.
Want to see how Zoho Office Integrator works? Check out this overview.
 
Try the new DATEDIF function in Zoho Office Integrator's document editor and let us know your feedback at support@zohoofficeapi.com or support@eu.zohoofficeapi.com or in the comments below.


If you have any functions that you want us to add, let us know in the comments.
 
Best regards,
The Office Integrator Team
    • Sticky Posts

    • Latest updates to Zia in Office Integrator

      Hello Zoho Office Integrator users! We’re pleased to share exciting updates to the proofing capabilities of Zia, our AI-driven writing assistant, in Office Integrator. With these updates, you can now get spell and grammar check in Brazilian Portuguese,
    • Role management in Zoho Office Integrator

      Hey Office Integrator users! We're pleased to announce that users now have the ability to assign role-based permissions, which empowers them to execute specific operations within Office Integrator and manage tasks like adding or removing user accounts
    • Introducing post-paid billing in Zoho Office Integrator

      Hey users, We're pleased to announce that you can now maintain uninterrupted business operations even after API calls associated with your Office Integrator subscription plan have expired. With our new flexible post-paid billing option, you have the flexibility
    • Recent Topics

    • Rich text support for Notes

      Hi! Is there an opportunity to add Rich text field to Zoho CRM? We need a field that can save the HTML-formatted text in it. It's crucial for our business. Moderation Updates: The votes for supporting Rich Text for multi-line fields is captured in the
    • Colour Coded Flags in Tasks Module List View

      I really like the colour coded flags indicating the status of the tasks assigned to a Contact/Deal in the module list view. It would be a great addition to have this feature available in the list view of activities/tasks. I understand you have the Due
    • Notes formatting

      I see that I can format this idea proposal with bold, underlines , colors, and dot points even multi-level dot points However, I cannot do the same for notes in leads, contacts, potentials, etc. in CRM. This makes notes very difficult to read. PLEASE
    • Linking records from different modules

      Hello, Is there a way to link customer call records from the 'Calls' module to specific account and contact records? I've realized that our customer meeting reports are linked to both the contact and the Account records, in related list fields but the
    • Quickly send emails and sync conversations with custom email addresses in CRM

      Editions: All editions DCs: All DCs Release plan: This enhancement has been released for customers in all DCs except IN and US. We will be enabling it for IN and US DC customers soon. [Update on 22 May 2024] This enhancement has been released for all
    • Business_hour (by minute)

      Hi Zoho Team business_hours formula can only give the difference of time or day between two dates. (In the time calculation, it can only calculate the exact time. For example, it can give the difference between 16:30 and 16:55 as 0.) I want to calculate
    • At transaction level Discounts for Zoho books UAE version

      Dear Team, Please add transaction level Discounts for Zoho books UAE version. I have been requesting Zoho team past 3 years, Transaction level Discounts is a mandatory option required for our business needs. Zoho books Indian version has the option then
    • Where do Review Questions appear on the Performance Assessment?

      Hi, I want to create a Performance Assessment including only compentencies with a multiple-choice format, and a final open-text question after the competencies asking for justification of the previous objective questions. Can Review questions work for
    • Exit details not linked on employee profile

      Dear Team, The exit details that were filled in are not appearing in the employee's profile, and it seems the data is missing entirely. Please advise on how to proceed. Regards, Preetika
    • Client Script: Any plans to add support for multi-select field with onChange

      Client Script is fantastic and the documentation lists multiselect form fields as unsupported. Just wondering if there are any plans to make this a supported field. https://www.zoho.com/crm/developer/docs/client-script/client-script-events.html 2. Field
    • Versioning of Quotes and Invoices

      Would be nice if Zoho Invoice would offer the feature of saving all versions of a quote or invoice during the process - so if quotes or invoices get changed over time - a version of the old ones exist and can be reviewed and reactivated if necessary ... ;)
    • Banking - User Roles - Access To Single Bank Account

      Hi, We have different locations with each location having a specific bank account for Expenses/Etc... Can you please confirm on whether it's possible to give a user (non accountant), specific access to only a single bank account as opposed to all accounts
    • Does Zoho US Payroll now support employees in multiple states?

      Does Zoho US now support having employees in multiple US states? I looked at the site and can't find and of the restrictions on multiple states anywhere.
    • Help! Unable to send message

      Help! Unable to send message I have this email sales<at>teadvancehydraulics<dot>com, but I couldn't send outgoing email. (Reason:554 5.1.8 Email Outgoing Blocked.) Can you please help?
    • CRM Mail merge issues

      How do you configure the page on mail merge, from ZCRM??. I have written a template and structured the filters. the print preview is on one page.  I merge the document.  The merge reformats and then the document formatting moves higher and higher until by page 5 you have two half letters!!!  Very frustrating. Does anyone know if I need to insert a page break or how to correct /format this so it doesn't happen?? Help.  L
    • New notecards not syncing across devices

      Hello. I just noticed this problem happen recently. A new note being created on one device is not appearing on a different device, even though they're supposed to be synced with each other through setting it up on your account. I don't know if there's
    • Power of Automation :: Auto update a custom field based on Parallel transition under Blueprint

      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
    • Push error with Zoho Books and Zoho CRM

      I have successfully linked Books and CRM but I have some push errors with the following message: "The customer associated to this record is not linked to module chosen in the current contact sync configuration." I am unable to work this out, could you help please.
    • Sales Tax Rates

      Why is the Tax Customization feature limited to 2 decimal points? This issue has been mentioned several times over the last few years but it has not been changed. From a programming stand point, this should be relatively easy. Third decimal point capabilities
    • Feature Request: Ability to copy notecards to Windows desktop

      Hello, Please consider adding the ability to copy notecards to Windows desktop. Thanks!
    • Add RSS Feed Feature to Zoho Desk Communities and Knowledge Base

      It would be very useful to be able to get updates on content which is relevant to me from Zoho Desk Communities through RSS and also push my own Zoho Desk Community content to other platforms through RSS.
    • Do Individual Forums within Categories, in Desk Community, Produce Their Own RSS Feed?

      Do Individual Forums within Categories, in Desk Community, Produce Their Own RSS Feed? If not, can anyone share a work-around that could help me get an RSS feed for individual category forums?
    • Add customer to account based on domain name.

      I generate reports based on a the account field, i.e. companyX. In GoToAssist, my last provider, there was an option to automatically assign new ticket creators to a company (or account) based on their domain name. So for example, if a new employee creates
    • Zoho One Apps is not populating once clicked

      Hi Support, The Apps Menu button (corner right next to my profile) is not loading. It keeps flashing but nothing is showing up. When I type quick in the search bar to locate quickbooks, it continues to flash with no apps shown. Thanks
    • Tablet Pencil + Fillable Form

      Hi There, I just started using Zoho Writer Forms for our team on iOS. I noticed that some functions support 'scribble' or tablet pens and some do not. Is there a function I am missing where any text field can support 'scribble' or handwriting/printing
    • CRM API v2 AdWords GCLID Parameter

      Hi, I'm using AdWords Integration with Zoho CRM using a third party webform and can't manage to insert the "gclid" parameter via Zoho CRM API Leads endpoint (version 2). I already checked the following articles: 1. https://www.zoho.com/crm/help/google-adwords/configure.html#Third_Party 2. https://www.zoho.com/crm/help/api-diff/ Form submission works fine. On server side the gclid is correctly included in API request. The Lead is created successfully. All fields (system and custom) are populated correctly
    • Zoho Writer can be slow to load sometimes

      Hello! I've noticed that whenever I restart my web browser (Firefox 2) and try to open Zoho Writer, it always shows the login screen first, even if I have an URL direct to the writing interface itself. I don't recall it doing this in an older version, so why does it happen now? Also, sometimes when starting Zoho Writer, it gets stuck: I see the word "Loading..." come up and the page half-extends but never fully loads. I have to refresh the page totally in order to get it to work properly, but doing
    • Mass email processes

      Hello, I'm looking to send about 7k emails out. I have them in CSV format with most being people I have previously communicated with. My questions are: * What is the process for using Zoho to send this group of emails out utilizing Microsoft 365 ? I'm
    • Zoho WorkDrive 5.0 : d’un outil vers une solution intelligente de gestion de documents

      Dans un monde de plus en plus orienté vers les données, les entreprises doivent non seulement gérer une masse croissante de données non structurées, mais aussi en extraire des informations stratégiques. L’intelligence de contenu répond à ce besoin en
    • Weekly Tips: Avoid any email mishaps using Zoho Mail's Email Recall

      Let's say you have just sent an important email to a recipient with an important attachment. Moments after hitting send, you realize the attachment is outdated and missing some critical updates. Sending another corrected version of the email without addressing
    • Messaging

      Whenever i send a mail to someone, it come with the my name of the company, instead of the name of my company.
    • Can't receive emails. MX Records are good apparently.

      Hello, For the past couple of days I have been able to send but unable to receive email through Zoho Webmail. I went into Admin Console and it says: MX Records are configured correctly and Your Domains MX Records are pointed to Zoho. Could you please
    • How can I customize my sales pipeline in Zoho.com CRM ?

      Hi to all intelligent community members I’m Namrata Hinduja Geneva, Switzerland, new member in Zoho.com and in this community. Please resolve my query - How can I customize my sales pipeline in Zoho.com CRM to track the progress of deals more effectively?
    • Error when adding phone number

      Hi Team, I'm getting an error when trying to authenticate using my phone, please see image attached. thanks, Jose
    • Zoho Projects iOS app update: Revamp of toast message and an option to view the whiteboard images

      Hello everyone! In the most recent Zoho Projects app update, we have brought in support for the following features: 1. Toast message revamp: We have enhanced the toast message banners to a bolder interface. You will now be updated on the progress of uploads
    • Send a new invoice data from Books to local certified solution via API json due local compliance

      Greetings, I hope you are doing well and staying safe. Due to local compliance regulations, I am required to issue invoices exclusively using locally certified software, which Zoho Books is not. However, we would like to continue using Zoho Books, so
    • How to Populate the Amount field of a Deal by subform's aggregate data

      https://help.zoho.com/portal/community/topic/custom-function-25-%c2%a0populate-the-amount-field-of-a-deal-by-calculating-the-number-of-related-products-and-its-unit-price I'm trying to do an Deal amount update like this guide but I use a subform to calculate the product amount and price instead. Please help me writing the code. regards
    • Unblocking Outgoing Emails on exports@carelyexport.com – Urgent Assistance Needed

      We are a newly established export-import startup operating under the business name Carely Export, and we are currently using Zoho Mail for our business communications. However, we are experiencing an issue where our outgoing emails are being blocked,
    • Property Management: Creating Amazing Appointment Scheduling Sites

      Sometimes a property management company can be very busy where even some time and effort saved can make a difference in a world. If you are a property manager, would you not like it if you could spend the wasted time managing appointments to get your job done? This is where getting a booking appointment platform lets you improve efficiency and save time. The enticing scheduling appointment platform can also help get more clients in than normal. It will help you contend with other companies that have
    • IP BLACKLISTED UCEPROTECTL3

      Your IP 136.143.188.56 was NOT directly involved in aabuse, but has a bad neighborhood. Other customers within this range did not care about their security and got hacked, started spamming, or were even attacking others, while your provider has possibly
    • Next Page