Hi
I have this formula that calculate the reminding months and days of a birthday but I have a lot of them and I would like a CF formula that will highlight the cell when there is 30 days left or a week left.
=DATEDIF(TODAY(),EDATE(B8,(YEAR(NOW())-YEAR(B8)+1)*12),"ym")&" Mois "&DATEDIF(TODAY(),EDATE(B8,(YEAR(NOW())-YEAR(B8)+1)*12),"md")&" Jours"
Thank you.
I have this formula that calculate the reminding months and days of a birthday but I have a lot of them and I would like a CF formula that will highlight the cell when there is 30 days left or a week left.
=DATEDIF(TODAY(),EDATE(B8,(YEAR(NOW())-YEAR(B8)+1)*12),"ym")&" Mois "&DATEDIF(TODAY(),EDATE(B8,(YEAR(NOW())-YEAR(B8)+1)*12),"md")&" Jours"
Thank you.