Hi all,
I hope someone can help, i need to create a excel sheet that will allow me to input dates but then get them to be reviewed against todays date for classification (eg out of date, in date, out of date soon).
Classification could be done by colour only if this is easier?

Basically, a) how do I set a date in a cell that updates itself to todays date on opening up the worksheet.

b) How can I set up a classification against the dates

Any help greatly appreciated!