View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MAANI MAANI is offline
external usenet poster
 
Posts: 23
Default how to count blanks before today's date?

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)