I made a birthday list

TLS49

Board Regular
Joined
Nov 26, 2019
Messages
77
Office Version
  1. 365
Platform
  1. Windows
NEW FAMILY & FRIENDS BIRTHDAYS.xlsb
ABCD
1NAME OF PERSONBIRTHDAYAGEBIRTHDAY NOTIFCATION
2TONYMonday, July 30, 199030HAPPY BIRTHDAY TONY
3THOMASMonday, July 12, 194377 
4JANEFriday, August 31, 194574 
5LINDA Thursday, December 10, 196455 
6KIMBERLYThursday, July 14, 196654 
7JOHNWednesday, September 7, 196653 
8GARYFriday, March 21, 196951 
9JEFF Friday, December 12, 196950 
10THOMAS IIFriday, May 15, 197050 
11ALANFriday, March 16, 197347 
12KORITuesday, July 2, 198535 
13CODIESunday, February 17, 199129 
14KYLESunday, February 17, 199129 
15KATEThursday, January 26, 199525 
16EMIELY Friday, August 2, 199623 
BIRTHDAY
Cell Formulas
RangeFormula
C2:C16C2=IF(B2="","",ROUNDDOWN((TODAY()-B2)/365.25,0))
D2:D16D2=IF(DAY(B2)&MONTH(B2)=DAY(TODAY())&MONTH(TODAY()),"HAPPY BIRTHDAY "&A2,"")




I want birthday date in order after date pass go at bottom of list.

Thanks you much

Thomas
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,977
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
If you mean sort by Month and day try putting the formula in E2, drag down, select all your data and sort on Column E (please note that my dates are in dd/mm/yyyy order.

Book1
ABCDE
1NAME OF PERSONBIRTHDAYAGEBIRTHDAY NOTIFCATION
2JANE31/07/194575HAPPY BIRTHDAY JANE31/07/2020
3EMIELY 02/08/199623 02/08/2020
4JOHN07/09/196653 07/09/2020
5LINDA 10/12/196455 10/12/2020
6JEFF 12/12/196950 12/12/2020
7KATE26/01/199525 25/01/2021
8CODIE17/02/199129 16/02/2021
9KYLE17/02/199129 16/02/2021
10ALAN16/03/197347 16/03/2021
11GARY21/03/196951 21/03/2021
12THOMAS II15/05/197050 15/05/2021
13KORI02/07/198535 02/07/2021
14THOMAS12/07/194377 12/07/2021
15KIMBERLY14/07/196654 14/07/2021
16TONY30/07/199030 30/07/2021
Sheet5
Cell Formulas
RangeFormula
C2:C16C2=IF(B2="","",ROUNDDOWN((TODAY()-B2)/365.25,0))
D2:D15D2=IF(DAY(B2)&MONTH(B2)=DAY(TODAY())&MONTH(TODAY()),"HAPPY BIRTHDAY "&A2,"")
E2:E16E2=IF(DATE(2020,MONTH(B2),DAY(B2))<TODAY(),DATE(2020,MONTH(B2),DAY(B2))+365,DATE(2020,MONTH(B2),DAY(B2)))
D16D16=IF(DAY(B16)&MONTH(B16)=DAY(TODAY())&MONTH(TODAY()),"HAPPY BIRTHDAY "&B16,"")
 

TLS49

Board Regular
Joined
Nov 26, 2019
Messages
77
Office Version
  1. 365
Platform
  1. Windows
Thanks you for help. How I have column E automatically sort when I open the file oldest to newest? I need help with vba code for that

Thanks You

Thomas
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,977
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Code goes in the ThisWorkbook module.
VBA Code:
Private Sub Workbook_Open()
Sheets("BIRTHDAY").Range("A1:E" & Sheets("BIRTHDAY").Range("A" & Rows.Count).End(xlUp).Row).Sort Sheets("BIRTHDAY").Columns("E"), xlAscending, , , , , , xlYes
End Sub
 

Phuoc

Active Member
Joined
Apr 29, 2016
Messages
313
=IF(DAY(B2)&MONTH(B2)=DAY(TODAY())&MONTH(TODAY()),"HAPPY BIRTHDAY "&A2,"")

1. Birthday = 11/2; Today = 1/12 => "HAPPY BIRTHDAY "?

2. Birthday = 29/2 => 4 years will be only once "HAPPY BIRTHDAY "?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,482
Messages
5,625,021
Members
416,065
Latest member
meiravmeron

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top