| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating to add years - including leap year
I have a function that needs to add 3 years to a date field. I am currently
adding 1095 days (3 years x 365) to the base number, but if there is a leap year in those three, I'm off by one day. How can I add three years and make sure that the extra day is included if one year is a leap year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does the Networkdays function allow for leap years | Excel Worksheet Functions | |||
| How does Excel allow for leap years? | Excel Worksheet Functions | |||
| Non Leap Years I want to show 28, leap years show 29 in an"IF" | Excel Worksheet Functions | |||
| Does "DATEDIF" function count leap years? | Excel Worksheet Functions | |||
| DATEDIF and leap years | New Users to Excel | |||
Threaded Mode
