How to Calculate Time Between Two Dates in Excel (Years, Months, Days)

[@PaulEBrownbill]

This is a really great function, wonder why it is not in the list of visible functions? thanks Paul

[@jhonathanalexandergonzales6662]

Amazing! Is it possible to do between hours? Minutes? Seconds?

[@rajishn]

any other formula if datedif not available in excel

[@mohamedabdalaziz6778]

all thx 🙏

[@larissaandrews7866]

Can you generate a fiscal year calculation based on two 27-pay-period months within a 12-month period, starting in the new fiscal year in October and ending the fiscal year at the end of September, following government terms of calculation?

[@teddyw.charawa8989]

You are a Billionaire in the making.

[@KarenShimp]

Is there a formula (secret or otherwise) to calculate an end date based on a start date and a number of 1- business days and/or 2- calendar days?