Re: Countif with a date range

[Paul Corrado]

Bill,

=COUNTIF(F14:F32,"<"&DATE(2003,9,7))-COUNTIF(F14:F32,"<"&DATE(2003,8,27))

For dates between 8/26/03 and 9/7/03

PC

 

[Bill]

Excellent! Thanks Paul!

Bill

-----Original Message-----
Bill,

=COUNTIF(F14:F32,"<"&DATE(2003,9,7))-COUNTIF (F14:F32,"<"&DATE(2003,8,27))

For dates between 8/26/03 and 9/7/03

PC






.

 

[mushtaque_asghar]

COUNTIF with DATE RANGE

Thanks dear, its nice and very useful for many users around the world. May Allah Bless you always and keep doing such good things for humanity...


Regards,

Mushtaque Asghar Shaikh

System Support Officer
The First MicroFinanceBank Limited
North Punjab & AJK, ETC Islamabad
Contact @ (+92) 333 7173375
Landline # (+92) 51 111 362 362
Extension # 407