Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Birthday calculations
Hi,
I am setting up a spreadsheet to calculate people's age and the number of days to their next birthday. Calculating their age I can do but calculating the number of days until their next birthday is proving a little difficult. I am currently using the formula =365-DATEDIF($C3,TODAY(),"yd") where the full dd/mm/yyyy birth date is in c3. It occurred to me that the formula will be correct for non leap years but will probably be one day out on leap years. I would welcome any suggestions on how to correct the above formula to compensate for leap years? -- Cheers . . . JC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
looping through a set of calculations | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
Calculations too long | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) |