| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding dates in columns
=COUNTIF(A1:A100,"<" & TODAY()-300)
Or, my prefernce would be: =TODAY()-300 in any cell (say B1) and use; =COUNTIF(A1:A100,"<" & B1) -- Regards Dave Hawley www.ozgrid.com "Roy" wrote in message ... 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding columns using dates, but getting wrong data | Excel Worksheet Functions | |||
| adding columns if the dates are the same and getting OT hours | Excel Worksheet Functions | |||
| adding columns if dates are the same | Excel Worksheet Functions | |||
| How can I insert columns of dates in between exsisting columns of | Excel Discussion (Misc queries) | |||
| Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
Threaded Mode
