| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Days more than 180 days prior to today
Bad data somewhere as the formula is OK
-- Don Guillett Microsoft MVP Excel SalesAid Software "Gregory Day" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Days more than 180 days prior to today
I've just responded to your other post.
Pete On Mar 28, 9:45*pm, Gregory Day wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Days more than 180 days prior to today
If you want from 180 days ago to today and assuming that there are no dates
later than today, then use: =COUNTIF(Clients!AC4:AC113,""&TODAY()-180) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Gregory Day" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Days more than 180 days prior to today
Thanks you all. It is fixed!
-- Thank you, Gregory "Gregory Day" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
