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=388104