View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kckar kckar is offline
external usenet poster
 
Posts: 1
Default date subtraction


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