Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting rid of +/- in date subtraction.. | Excel Worksheet Functions | |||
Date Subtraction | Excel Worksheet Functions | |||
date subtraction | Excel Worksheet Functions | |||
Date subtraction -How to not show negative when 2nd date not entered | New Users to Excel | |||
Date subtraction question | Excel Programming |