Rachelle Haid is a an Excel wiz and came across this snazzy feature that finds the number of years, months, or days between two dates.
If you want to know the number of days between 2 dates, just type: =DATEDIF(CELL1,CELL2,”d”).
If you want to know the number of months between 2 dates, just type: =DATEDIF(CELL1,CELL2,”m”).
If you want to know the number of years between 2 dates, just type: =DATEDIF(CELL1,CELL2,”y”).
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare
One Comment