I assume F3 is the cell with the start year in it
in a blank cell enter
=mod(year(today())-year(F3),5)
in another blank cell enter
=mod(year(today())-year(F3)-1,5)
are the answers what you expect?
I am wondering if your F column is text rather than dates.
if they are, try
if(F3<"",(mod((year(today())-year(value(F3))),5)=0)
"PAR" wrote:
Does not work. Is it because I have the formula year(today())-Year(f3) as
the contents of the cell?
I need to have the same color for all multiples of 5 years. So if the
answer to year(today())-Year(f3) = 5, or 10, or 15, or 20, or 25, or 30, or
35,etc the color of the font or pattern changes
"bj" wrote:
if the same color is acceptable for each multiple of 5
try
if(A3<"",(mod((year(today())-year(A3)),5)=0)
and set your format
"PAR" wrote:
I would like to have a cell turn a color when the value of the following
formula is a multiple of 5.
Year(today())-Year(b2)
b2 = date of hire
Thank you
|