date calculation

[Ann]

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

 

[Peo Sjoblom]

COUNTIF(M6:M400,">"&$B$1)

do the same for the second date

Btw, if you want to include 05/18/2008 you would need

COUNTIF(M6:M400,">="&$B$1)



--


Regards,


Peo Sjoblom

 

[pdberger]

Ann --

Try

=COUNTIF(M6:M400,">"&B1)-COUNTIF(M6:M400,">"&B2)

Worked for me.

HTH

 

[Ann]

thanks, worked!

Ann --

Try

=COUNTIF(M6:M400,">"&B1)-COUNTIF(M6:M400,">"&B2)

Worked for me.

HTH