how to count blanks before today's date?
On Sat, 13 Sep 2008 07:56:41 GMT, 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:IK 2)))
Hope this helps / Lars-Åke
Actually the formula I gave included todays data.
In order to have only the blanks BEFORE todays data, a -1 should be
included, like this:
=COUNTBLANK(OFFSET(C4:C159,,,,MATCH(TODAY(),C2:IK2 )-1))
Lars-Åke
|