Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting rid of +/- in date subtraction.. Mark Excel Worksheet Functions 4 February 4th 09 01:21 PM
Date Subtraction Newbie Excel Worksheet Functions 3 January 17th 09 06:16 PM
date subtraction [email protected] Excel Worksheet Functions 6 December 9th 08 02:13 PM
Date subtraction -How to not show negative when 2nd date not entered Edward[_2_] New Users to Excel 2 September 27th 07 03:03 PM
Date subtraction question Jeff Excel Programming 2 January 10th 05 12:08 AM


All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"