roy.okinawa

Posts: n/a

Computing a date range

I want to have two cells where I enter the start date and end date to
sum/count totals between that date range. I can get it to work if I just
enter one date. See below.
=SUMPRODUCT(--(MONTH(V45:V1014)=MONTH(AU52)),--(ISNUMBER(SEARCH(AS61,N45:N1014))))

What is the rest of the formula to compute the end date as well?

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
How do I get an IF statement to pull a date range??	Brooke Medvecky	Excel Worksheet Functions	9	April 19th 06 08:48 PM
Date Range within one cell	Cachod1	New Users to Excel	5	October 18th 05 03:30 AM
Date Range and calculation	vgreen	Excel Worksheet Functions	2	August 23rd 05 11:08 AM
Update cell based on date range	deversole	Excel Discussion (Misc queries)	3	July 6th 05 01:58 PM
Count cells based on date range in another column	[email protected]	New Users to Excel	1	May 5th 05 08:11 PM

All times are GMT +1. The time now is 06:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us