| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif only after specified date
I have this formula:
=IF(COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,5,1))0,"No","Yes") I would like it to keep the cells blank and only complete the calculation after 4/31/08. Any ideas? Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif only after specified date
Maybe...
=if(today()<date(2008,5,1),"",yourformulahere) hmsawyer wrote: I have this formula: =IF(COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,5,1))0,"No","Yes") I would like it to keep the cells blank and only complete the calculation after 4/31/08. Any ideas? Thank you! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif only after specified date
Perfect!
Thanks so much! "Dave Peterson" wrote: Maybe... =if(today()<date(2008,5,1),"",yourformulahere) hmsawyer wrote: I have this formula: =IF(COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,4,1)) - COUNTIF('Employee Attendance'!3:3,"="&DATE(2008,5,1))0,"No","Yes") I would like it to keep the cells blank and only complete the calculation after 4/31/08. Any ideas? Thank you! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif within date ranges | Excel Worksheet Functions | |||
| Countif only col a = col b by date | Excel Worksheet Functions | |||
| countif date | Excel Worksheet Functions | |||
| CountIf on Date field | Excel Worksheet Functions | |||
| Using Countif for Date Matches | Excel Worksheet Functions | |||
Linear Mode
