Hi,

In Excel dates are numbers so try this

=IF(COUNT(B1:E1)=4,"R","")

Mike

"andim" wrote:

I just wanted to know if there is a way that I can check the content of
several cells with a function (possibly IF) to return a value in A1 if the
cells referenced all have a specific value.

To clarify I want A1 to return text "R" if B1, C1, D1 and E1 all have dates
in them.