datedif function calc

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

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 gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips


Server loaded in 0.2 secs.