birthday

  1. A

    Using Index/Match with an IF Statement???

    I don't know if it is possible, but is there a way to use index/match in an IF statement? Or maybe something else will work. I have a range of A5:F250 with a list of events for different entries. Column A = First Names Column B = Last Names Column D = Name of Events (Birthday, Deceased...
  2. O

    Looking for an If formula

    I am looking to use a IF formula but not sure how to write it so it returns the value i want. I have a list of SKU's that have a location by them, i also have a separate list of locations. I want the If formula to return a value of 1, if the SKU's location appears in my 2nd list...
  3. W

    Months and Days Until Next Birthday - 2019 update

    Hi, I was looking for a formula to calculate Months and Days Until Next Birthday. I found this thread https://www.mrexcel.com/forum/excel-questions/355165-months-days-until-next-birthday.html It works well, unless the birthday month and day are the same as today. In that case (e.g. birthday...
  4. N

    Un-flatten Survey Data

    I have survey data that requests responses from parents about the number of kids they would like registered for an activity. <tbody> Parent Name Child 1 Name Child 1 T-Shirt Size Child 1 Birthday Child 2 Name Child 2 T-Shirt Size Child 2 Birthday Child 3 Name Child 3 T-Shirt Size Child 3...
  5. C

    Automatic birthday emails

    Can you advise in very simple terms, how I can get a spreadsheet with our colleagues birthdays to automatically generate a personal birthday email please?
  6. K

    Happy birthday bill jelen!

    Happy birthday Bill Jelen!!
  7. R

    Using Gmail to Send Excel Grades Home to Students and Their Parents

    Dear Sir or Madam: My name is Markus, and today is my birthday. Therefore, I am hoping Mr. Excel can provide me with a very special birthday gift. I am a teacher who is trying to send Excel student grades via Gmail to students and their parents. I don't want to involve a another component such...
  8. M

    Birthday Spreadsheet

    Hi Need some help building a simple formula. I would like A1 to be populated with the name of the person when it's 3 weeks before their birthday, I've created a table array called Birthday, see below <colgroup><col><col></colgroup><tbody> Name Birthday Bert Smith 09-Jun Roger Rooster...
  9. B

    How to create birthday alert/warnings?

    With this code i take out the birthday date from a socialnumber (personnummer in sweden) Sub GetBirthdayDate() Application.Echo False On Error GoTo PROC_ERR Dim dat Dim year Dim mounth Dim day Dim age year = Left(Form_Profile_Form.txtProfilePersonnummer, 2) mounth =...
  10. S

    Need to send Email to whole team for Birthday Wishes using VBA

    Hi All, Need help on below requirement: I need to send email's to whole team for Birthday wishes Need to have a Macro I wanted to embed an image below the birthday wishes text. Regards, Sajith
  11. S

    Auto send birthday email

    dear friends, I have my team birthday list in excel sheet I am send greeting to manually in outlook. Now I want to send the greeting automatically when the date will come and send the copy with my all team members also is there any VBA code please provide me i will attached the sample sheet
  12. S

    Calculate days since last birthday

    I want to calculate the days since someone's last birthday. In cell A1 I have today's date and in cell B1 I have their date of birth. In cell C1 I want a formula that calculates the days since their birthday (not the days since their date of birth). Any suggestions?:confused:
  13. melissarose

    How to calculate a person's NEXT age rather than current age?

    I wanted to make a table alongside my personal budget showing me when each person's birthday is and how old they are next going to be, since I always forget. I can get their current age by using the formula =DATEDIF(A1,TODAY(),"y") I tried just changing it to =DATEDIF(A18,TODAY(),"y")+1 but it...
  14. I

    Find all birthdays from all worksheets

    Hello. This is my first post in here so excuse me for my complicated explanation. I have a workbook where I have about hundred worksheets. First worksheet is so called frontpage and the others are clients/companies. Worksheets are named accordig to the clients and companies. In cli/com...
  15. M

    Advanced age display from birthday

    Hi I work on a paediatric ward in a hospital and my boss has set me a challenge for our handover sheet. If I enter the birthday of a child, I can have the age displayed as 1y10m6d for eg. What we want is if the child is younger than 1 to have just 2m5d displayed for eg. If aged 1-3 have 1y4m...
  16. repairman615

    Happy Birthday VoG

    I find your posts very helpful in beginning to understand VBA. I cannot return the gift you have extended here, so I will Just say, Thank You.
  17. Goldfield

    Data or Formula in Same cell

    Hi everybody I have two cells A1: Birthday) and A2: Age) Using VBA I want A2 to display the age if i type the birthday in A1 using a formula like this one...
  18. D

    Birthdate Calculations w/Set Stop Date

    Hello Everyone, I am looking for a formula that calculates an individuals exact age given their date of birth, that shows their age in years (possibly with two decimal points.) I have seen the formulas using the TODAY() option, however I will need the stop date to be effective 05-JAN-08...
  19. P

    Help on Access Template

    Hi Guys, I'm just starting out on access and have downloaded some templates from microsoft to start. I'm looking at one in particular http://office.microsoft.com/en-us/templates/TC010185811033.aspx and there is one report which selects birthdays this month. I've looked and looked and can't work...

Watch MrExcel Video

This Week's Hot Topics

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