need help with formula?

[kckar]

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]

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

[Dave Peterson]

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