View Single Post
 
Old 06-08-2017, 01:17 PM
bonth123 bonth123 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jun 2017
Posts: 3
bonth123 is on a distinguished road
Default converting a return of days in a formula to year 1, 2, 3 ect.

I am trying to figure out how to make my simple formula (=TODAY()-I2) return a year, i.e. if the days are 0-365 it would return a 1, 366-730 it would return 2, etc. Any help would be greatly appreciate...I am fairly well lost in most excel functions
Reply With Quote