# 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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,095,782
Messages
5,446,471
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top