| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating days between dates and leap years
Since when has 2005 been a leap year? In a (true) leap year, you will get
365. -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating days between dates and leap years
I realized after I posted it.. I had it backwards.....but thanks for your
help. I'll just add one to my formula.. "Bob Phillips" wrote in message ... Since when has 2005 been a leap year? In a (true) leap year, you will get 365. -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating days between dates and leap years
But why, it works fine without?
-- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... I realized after I posted it.. I had it backwards.....but thanks for your help. I'll just add one to my formula.. "Bob Phillips" wrote in message ... Since when has 2005 been a leap year? In a (true) leap year, you will get 365. -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating days between dates and leap years
Becasue... when I enter 1/1/05 to 12/31/05 (I'm calc. the days worked by
employees)... this should be a full year of 365 days that they worked ...and it comes up to 364 days..... "Bob Phillips" wrote in message ... But why, it works fine without? -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... I realized after I posted it.. I had it backwards.....but thanks for your help. I'll just add one to my formula.. "Bob Phillips" wrote in message ... Since when has 2005 been a leap year? In a (true) leap year, you will get 365. -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating days between dates and leap years
SO they work every day, no weekends off, no bank holidays or leave?
You might want to check NETWORKDAYS from the Analysis Toolpak which calculates working days between two dates (and includes both dates) -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... Becasue... when I enter 1/1/05 to 12/31/05 (I'm calc. the days worked by employees)... this should be a full year of 365 days that they worked ....and it comes up to 364 days..... "Bob Phillips" wrote in message ... But why, it works fine without? -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... I realized after I posted it.. I had it backwards.....but thanks for your help. I'll just add one to my formula.. "Bob Phillips" wrote in message ... Since when has 2005 been a leap year? In a (true) leap year, you will get 365. -- HTH RP (remove nothere from the email address if mailing direct) "KimberlyC" wrote in message ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
