see ans in your 6 minutes later post

--
Don Guillett
SalesAid Software

"Kerry" wrote in message
...
I am trying to write a formula that results in the earliest date using min
except that a blank cell on any page results in a 0.
=MIN('1Jan-9Jan'!R196,'10Jan-16Jan'!R196,'17Jan-23Jan'!R196)
What do I need to do to ignore the blank cells