Hey all,

I have a large excel file with employee data, I am trying to track expiring dates and have come up with this

=SI(DATEDIF(A6;AUJOURDHUI();"yd")<=0;"EXPIRED!!";"Expiration de Visa dans "&AUJOURDHUI()-DATE(ANNEE(A6)+DATEDIF(A6;AUJOURDHUI();"y");MOIS(A6);JOUR(A6))&" jours")

it works fine but problem is that it doesnt calculate future dates.....

also I would need to have cells change color when its about to expire in a months time so that I can see the change and do something about it.

anyone know what I should do?

thanks xxoo