combining statements

J

Jack

Hello
Is there a way to use an IF statement to Combine statements from multiple
sheets based on a date?

Thanks
 
B

Bob Phillips

Do you mean something like

=IF(AND(Sheet1!A1<TODAY(),Sheet2!A1<TODAY()),"Both less","Not both less")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top