# CF for remaining birhday date.

#### serge

##### Well-known Member
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.

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Try something like this...

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

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

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

Serge.

Last edited:

Replies
2
Views
621
Replies
1
Views
394
Replies
0
Views
547
Replies
6
Views
181
Replies
1
Views
132

1,216,309
Messages
6,130,001
Members
449,552
Latest member
8073662045

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back