Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with formula?
is there a formula where i can exclude a date (february 29) that occurs between two given dates so that whenever a leap year occurs it doesnt calculate it into days between two dates ex when you subtract 06/04/2005-07/04/2003=701 because that includes the leap year i want to be able to take out february 29 (2004 was a leap year so that it equals 700) -- kckar ------------------------------------------------------------------------ kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322 View this thread: http://www.excelforum.com/showthread...hreadid=388083 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with formula?
is there a formula where i can exclude a date (february 29) that occurs between two given dates so that whenever a leap year occurs it doesnt calculate it into days between two dates ex when you subtract 06/04/2005-07/04/2003=701 because that includes the leap year i want to be able to take out february 29 (2004 was a leap year so that it equals 700) i was thinking something like the networkindays function but instead of excluding weekends and holidays you include them and only exclude february 29 -- kckar ------------------------------------------------------------------------ kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322 View this thread: http://www.excelforum.com/showthread...hreadid=388083 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with formula?
You have replies to your post in .worksheet.functions.
kckar wrote: is there a formula where i can exclude a date (february 29) that occurs between two given dates so that whenever a leap year occurs it doesnt calculate it into days between two dates ex when you subtract 06/04/2005-07/04/2003=701 because that includes the leap year i want to be able to take out february 29 (2004 was a leap year so that it equals 700) i was thinking something like the networkindays function but instead of excluding weekends and holidays you include them and only exclude february 29 -- kckar ------------------------------------------------------------------------ kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322 View this thread: http://www.excelforum.com/showthread...hreadid=388083 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |