Hi there,
Just signed up as have come across some of the excellent advice you guys seem to have on similar topics! Have tried to follow guides on similar topics, but unfortunately my lack of understanding is making editing parts of the formula to meet my requirements a bit tricky lol...
Basically I'm trying to make it so that the date entered for a particular training session will be green if it is within the 2 years of that date (so it is still active)
Then Amber if it is 3 months to go until the date expires
Then Red if it has actually passed 2 years and expired.
The closest formula that seemed to do what I want is when using the icon sets on excel:
=DATE(YEAR(TODAY()),MONTH(TODAY())-30,DAY(TODAY())) This one for Green
=DATE(YEAR(TODAY())-3,MONTH(TODAY()),DAY(TODAY())) and This one for Amber
but I really wasn't clear on what I'm meant to change in that formula (was guessing the -30 and -3, but tried various changes and couldn't figure out what I was meant to change it to ) Think those formulas were for 3 years till expiration date, and 6 month warning.
Any help would be much appreciated, so I will know what part of the formula to change for different training as they all have different amount of years till expiration etc.
Thanks team x
ps. sorry if it's just me being very simple minded!
Bookmarks