If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Adding dates in columns
Try
=COUNTIF(A:A,"-="&TODAY()-300) -- HTH Bob "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. |
#3
|
|||
|
|||
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 | |
Display Modes | |
|
|