I'm trying to look at two cells, and if either has a date in it I want that
date in a third cell (where the formula is).

This formula works: =IF(COUNT(tab!$AF6)=1,MAX(tab!$AF6),"")

for checking one cell, but I also want to check (tab!AQ6) for a date. Any
suggestions?

Thanks.

In general you can have multiple logical tests in an IF statement

=IF(AND(test1,test2),action if true,action if false)

=IF(AND(COUNT(tab!$AF6)=1,tab!AQ6 = Today()),MAX(tab!$AF6,"")

However your test if AF6 = 1, is true then MAX of it will also be 1 !

--

Regards,
Nigel




"Skeeterj" wrote in message
...
I'm trying to look at two cells, and if either has a date in it I want
that
date in a third cell (where the formula is).

This formula works: =IF(COUNT(tab!$AF6)=1,MAX(tab!$AF6),"")

for checking one cell, but I also want to check (tab!AQ6) for a date. Any
suggestions?

Thanks.