CF for remaining birhday date.

[serge]

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.

 

[AlphaFrog]

Try something like this...

=DATEDIF(B8,TODAY(),"yd")<=7

=DATEDIF(B8,TODAY(),"yd")<=30

 

[serge]

Thank you AlphaFrog for the respond, it works perfectly fine, I appreciate the help.

Serge.