| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Days to Years ? How
Currently i have an induction register that has 3 worksheets.
sheet1 = Date the induction was carried out sheet2 = Frequency that the induction is current for(At moment i have 365.25 as 1 Year) sheet3 = Display of dates due with colour coded shading according to when the induction is due. Is there a a way i can in SHEET2 place 1,2,3,5,10 for YEARS rather than 365.25 for 1 year etc? Regards Corey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem With Converting Days Months And Years | Excel Discussion (Misc queries) | |||
| problem of calculating years months and days | Excel Discussion (Misc queries) | |||
| problem of converting days months and years | Excel Worksheet Functions | |||
| problem with days months and years conversion | Excel Worksheet Functions | |||
| convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
Threaded Mode
