Bit of help with Excel highlighting date field for warranty

Associate
Joined
15 Dec 2002
Posts
404
Hi,
I have a spreadsheet with approx 300 records. I want to creat a new column to mark items in and out of warranty. I have date supplied I just can't figure out hot to automatically have a new field to calculate if the item is more than 365 days old.

Help would be much appreciatedl
 
Back
Top Bottom