need help with formula?

  • Thread starter Thread starter kckar
  • Start date Start date
K

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)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need formula help 3
Excel DateDif - why does 2007 seem different? 3
Calc Prorated Cost based Specific Days in a Gven Month & Year Range. 3
If a date range contains a leap year (date) 14
Datedif gives wrong result 1
Average between dates considering leap years. 6
Average days between multiple dates 4
Seniority Years Formula needed 5

Back
Top