ExcelBanter - Countif only after specified date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif only after specified date (https://www.excelbanter.com/excel-discussion-misc-queries/181207-countif-only-after-specified-date.html)

hmsawyer

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!

Dave Peterson

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

hmsawyer

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

All times are GMT +1. The time now is 07:18 PM.