Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count If Statement Using Dates
I want to check a spreadsheet and count the cell based on dates. If the date
in the cell is less than 7 days before today then count. Then another count if for if the date is 8 to 30 days before today. Any suggestions would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count If Statement Using Dates
try
=sum(if(today()-range<7,1,0)) entered as an array control-shift-enter and =sum(and(today()-range7,today()-range<=30,1,0)entered as array what happens when it is 7 days exactly? you may need to add an = to one of the equations "Chris O''''Neill" wrote: I want to check a spreadsheet and count the cell based on dates. If the date in the cell is less than 7 days before today then count. Then another count if for if the date is 8 to 30 days before today. Any suggestions would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement with dates | New Users to Excel | |||
IF statement with two dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Help with Count IF Statement | Excel Discussion (Misc queries) | |||
count if statement | Excel Discussion (Misc queries) |