Posted to microsoft.public.excel.worksheet.functions

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Date Calculation

On Tue, 29 May 2007 14:27:25 -0700, LeapYear
wrote:

I would like to calculate the number of days within a span of years without
February 29th. In other words, I don't want to recognize the 29th day of
February within leap years.

Try this:

=A2-A1-SUMPRODUCT((MONTH(ROW(INDIRECT(A1&":"&A2)))=2)*
(DAY(ROW(INDIRECT(A1&":"&A2)))=29))

--ron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Date calculation	Funkyfido	Excel Worksheet Functions	3	March 22nd 07 10:04 AM
Tricky Date calculation: How to calculate a future date	[email protected]	Excel Discussion (Misc queries)	9	August 11th 06 04:24 AM
Date Calculation	Steve	New Users to Excel	4	August 3rd 06 06:15 PM
Date calculation	MIchel Khennafi	Excel Worksheet Functions	3	April 27th 06 07:35 PM
Due Date Calculation?	Randy	New Users to Excel	11	July 14th 05 07:44 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us