Posted to microsoft.public.excel.worksheet.functions

ann

external usenet poster

Posts: 210

date calculation

i currently have this formula
=COUNTIF(A1:A15,"5/18/2008")-COUNTIF(A1:A15,"5/22/2008")
if i want to pull the dates and put them in a separate field and reference
that field, how do i do it? the syntax i have won't work.

i'm trying =COUNTIF(M6:M400,"$b$1")-COUNTIF(M6:M400,"$b$2") where
b1=5/18/2008 and b2=5/22/2008

TIA

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	Donald[_2_]	New Users to Excel	2	February 12th 08 03:19 PM
End Date Calculation (adding a start date duration)	Silena K-K	Excel Discussion (Misc queries)	5	January 25th 08 04:27 PM
date calculation	Pammy	Excel Discussion (Misc queries)	4	June 12th 07 10:15 PM
Tricky Date calculation: How to calculate a future date	[email protected]	Excel Discussion (Misc queries)	9	August 11th 06 04:24 AM
Date Calculation	Mukund	Excel Worksheet Functions	3	January 11th 05 11:29 AM

All times are GMT +1. The time now is 02:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us