How do I track dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I track the safety training for our company and we have several that have to
be renewed yearly. I have an Excel spreadsheet the has the dates of the
training but I need to find a way to change the cell color (conditional
format), the only problem I am having is figuring out how to get Excel to
keep up with the current date and the training date and letting me know when
it needs to be done again. Does anyone have any suggestions ?
 
Put =TODAY() in A1 and in B1 put the due date. A1 will update everytime the
worksheet is openned. Now if B1 is greater than A1, then the due date is in
the future and no flag is necessary. If B1 is less than A1, then the due
date is past due and should be flagged.


Select B1 and pull-down:
Format > Conditional formatting... and select formula is and enter:

=(B1<A1) then set the background color to something flashy


Adapt this for your your data structure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking due dates 2
Need to know formula to make expire in a year. 4
Cell color changes when date gets closer 2
past date cell colour change 1
Date Functions & Formatting 6
Conditional formatting on Date 5
Date calculation 1
training tracker 3

Back
Top