serge
Well-known Member
- Joined
- Oct 8, 2008
- Messages
- 1,442
- Office Version
- 2007
- Platform
- Windows
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.