When will the course expire?

Assume 180 days after completion.

FormatCFFormula is =cellref<TODAY()-180


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:28:00 -0700, Deeno
wrote:

I have a spreadsheet where I have inputed dates (mm/dd/yyyy) when training
classes were completed. I am trying to create some way of notifying user
(conditional formating?) that the course is expired, but cannot seem to get
it to work.

The sheet is set up in this format:

Name Class1 Class2 etc
John Date Date etc
bob date etc etc
etc etc etc etc