98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » DATEDIF function - calc no. of months when above 1 year
DATEDIF function - calc no. of months when above 1 year
Resolved · Medium Priority · Version 365
Jessica has attended:
Excel Advanced - Formulas & Functions course
DATEDIF function - calc no. of months when above 1 year
Within my work I need to know the number of months between two dates. This is so I can know the duration of the grant.
I was hoping to use the DATEDIF function but can't get it to work as the dates are all over 12 months. The function only goes up to 11 months.
If the dates are 12 months or over apart it will just display 0.
for example
01/09/2021
31/08/2023
As the grant runs up to 23:59 on 31/08/2023 the duration for this example grant would be 24 months.
Through Datedif I get 0.
Is there a way to do this through a function?
RE: DATEDIF function - calc no. of months when above 1 year
Hi Jessica,
Thank you for the forum question.
when I try with your dates the datedif function return the right result.
=Datedif(start date, end date, "m")
01/09/2021 if this date is in A1
31/08/2023 if this date is in B1
=Datedif(a1,b1,"m")
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Tue 14 Mar 2023: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlinesExcel 2010 allows you to change the colour of grid lines instead of keeping them in boring black. |