| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Days more than 180 days prior to today
On sheet two I have a column of dates formatted as 3/28/2008. I would like to
add a cell on Sheet1! that looks at that column and counts the number of entries that are 180 days prior to today or higher.I tried this with out luck. =COUNTIF(Clients!AC4:AC113,(TODAY()-180)) but it just gave me 0 though there was 1 in the column. -- Thank you, Gregory |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When word says Install I want it count the days for 3 days w.o wee | Excel Worksheet Functions | |||
| COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
| How do I use the IF formula to flag dates 21 days prior to deadlin | Excel Worksheet Functions | |||
| Subtracting a time from a day and 2 days prior | Excel Discussion (Misc queries) | |||
| Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
Threaded Mode
