# of months or year between start and end dates

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
Hi
I know how to find number of days between start and end dates by simply subtracting end-start. I also know how to find how many working days between start and end date using networkdays() function. My question, how can I find # of months between a start and end dates? and also can I find how many years between a start and end date? Thank you so much.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Forum statistics

Threads
1,089,224
Messages
5,406,951
Members
403,113
Latest member
ms_excel_recal_or_die

This Week's Hot Topics

Top