The formula expects the dates to be "numbers formatted as date"a nd
not "text". Maybe that is why you don't get the expected result.

Lars-Åke


On Sat, 13 Sep 2008 04:49:01 -0700, MAANI
wrote:

Returned zero

"Lars-Åke Aspelin" wrote:

On Sat, 13 Sep 2008 00:26:01 -0700, MAANI
wrote:

C2 to IK2 have dates from 1-Aug-08 to 31-Mar-09, B4 to B159 eployee names,I
want a formula to count blanks before todays date,Example:if today is
4-Aug-08, I want the formula to return 312 which is countblank(C4:E159)


Try this formula:

=COUNTBLANK(OFFSET(C4:C159,,,,MATCH(TODAY(),C2:IK2 )))

Hope this helps / Lars-Åke