If formula troubles

Hi,

I'm creating a training spreadsheet and need to show whether all completed essential training is still in date or not. Therefore I need to work out a formula that will look at a number of specific cells, and if the dates in any of these cells is in the past then the formula should return a 'N' to indicate that training is not up to date. Even just one cell with a date in the past should return an 'N' value. If all the dates are in the future then I need it to return a 'Y'.

Thanks for your help.

Thank you very much Richard Buttrey. I have five dates to take into account and they are dotted around the spreadsheet, so your first suggestion worked a treat.

Very much appreciated.

Ah, actually, I should have said that if the cell is actually blank I need it to return an "N". Not all my cells have dates e.g. if the person has not completed the training at all. So its actually if its out of date or blank. The above solution worked but ignored any blank cells and returned a Y as long as the dated cells were in date. How can I incorprate this into the formula?

I'll try to upload a sample of data.

Thanks for your help.

Okay, I think I've managed to upload a sample.

The formula goes into column F. And its the Refresher Due columns that I'm trying to work with (columns H, K, M, P, S)

Thanks again.

Perfect Sambo Kid. Thanks very much! Thats great.

Seems so obvious when I look at your formula, but I just couldnt quite get it right. Much appreciated.