View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roy Roy is offline
external usenet poster
 
Posts: 53
Default Adding dates in columns

Using 2003, I am entering dates and trying to utilize a formula to calculate
the number of cells that fall before a certain date.

<"Today()-300", calculates the cells that are in the range.

I have tried the countif and sumif formulas, but they do not like ranges
within the criteria as noted above.

Tried an aray formula without getting it to work.

Any help would be appreciated.