Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Check column of dates against todays date
I have a column of dates that I need to sort through. At the moment I am using
=COUNTIF(E8:E1000,"<15/04/2005") to check dates that were before todays date. Now I would like to have this formula change with the date. I have tried having a cell with =TODAY() in it then referencing that cell in the formula: =COUNTIF(E8:E1000,"<A1") but it just returns 0. Any ideas? Hope so!! |
#2
|
|||
|
|||
Andrew,
Try =COUNTIF(E8:E1000,"<"&TODAY()) or =COUNTIF(E8:E1000,"<"&A1) -- HTH RP (remove nothere from the email address if mailing direct) "Andrew82" wrote in message ... I have a column of dates that I need to sort through. At the moment I am using =COUNTIF(E8:E1000,"<15/04/2005") to check dates that were before todays date. Now I would like to have this formula change with the date. I have tried having a cell with =TODAY() in it then referencing that cell in the formula: =COUNTIF(E8:E1000,"<A1") but it just returns 0. Any ideas? Hope so!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula | New Users to Excel | |||
Adding a column based on greater than a date | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Date in descending order to come up automatically in a column? | Excel Worksheet Functions |