| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating days between dates and leap years
Hi
I have a "from" date in col A and a "to" date in Col B In Col C, I'm using the following formula to find the days between the two dates in A and B. =B8-A8 Is there something I can add to this formula to add one day to the answer in col C ....if it's a leap year. For example, if I have 1/1/05 in A8 and 12/31/05 in B8, the answer is 364...and I need it to be the full year of 365 days. Not sure how to adjust the formula for leap year or if that is possible.. Thanks in advance for you help.. Kimberly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average between dates considering leap years. | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Calculating to add years - including leap year | Excel Worksheet Functions | |||
| problem of calculating years months and days | Excel Discussion (Misc queries) | |||
| Calculating days between dates and leap years | Excel Programming | |||
Threaded Mode
