|
|
#1
06-08-2017, 01:17 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
| Formula for week days only | gbaker | Excel | 5 | 02-15-2014 01:07 AM |
| Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |
 Converting serial number to years, months and days
|
hannu | Excel | 6 | 02-14-2013 09:21 PM |
| Formula to calculate Leap Year | USAOz | Excel | 2 | 09-11-2011 04:58 PM |
Windows 7 64bit 
Office 2007
Threaded Mode