View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kckar[_3_] kckar[_3_] is offline
external usenet poster
 
Posts: 1
Default i need formula help


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