Same Date All Worksheets TRUE/FALSE Formula

[dragonmouse]

I'm trying a different route to my attendance workbook. I think it can be done with a formula rather than VBA, but I'm not wise enough. So I'll just "pretend" to write it.

"If (A1 Date =TODAY()Worksheet1 and A1 Date=Today()Worksheet2 and A1 Date=Today()Worksheet3) THEN TRUE, otherwise FALSE."

I'm going to have everyone enter the date in a preformatted cell A1 on their respective worksheets, If all the dates in all three worksheets MATCH the "current date", then on my "consolidated" worksheet in Cell B1, I want it to return TRUE otherwise return FALSE.

This will tell me that I need to find out which workcenter has not done their attendance or if it's complete. Thoughts?

 

[Fluff]

How about

=AND(Sheet1!A1=TODAY(),Sheet2!A1=TODAY(),Sheet3!A1=TODAY())

 

[dragonmouse]

Ohhh BOY...Ohhhh BOY!!!! BINGO! That WORKS BEAUTIFULLY. SCORE. THANK YOU SOOOOOOOO MUCH

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Crystalyzer]

=IF(MAX(Sheet2:Sheet4!A1)=MIN(Sheet2:Sheet4!A1),TRUE,FALSE)

 

[Fluff]

@Crystalyzer that doesn't take into account todays date.

 

[Crystalyzer]

OOOOOPS Updated

=IFS(MAX(Sheet2:Sheet4!A1)=MIN(Sheet2:Sheet4!A1),IF(TODAY()=Sheet2!A1,TRUE,FALSE),TRUE,FALSE)

 

[Fluff]

Or just the far simpler formula in post#2

 

[dragonmouse]

Thank you

 

[Fluff]