birth

If you are not aware, in the UK we have National Minimum Wage that varies on your age. The ranges are 16-17, 18-20, 21-24, 25+ I have members of staff of varying age that can move through the various rates of pay. I have a cell with the member of staff's date of birth. I have grid of cells with...

Hello forum friends, need help with this formula as it is returning a result of 19919 if I enter a date of birth in 'personal information'!E5. I entered May 6, 1954 in 'personal information'!E5 hoping to see a result of 2019. =IF('personal information'!E5=0,"",'personal information'!E5+69)...

My data is in one column as follows: NAME DATE OF BIRTH HIRE DATE TERMINATION DATE NAME DATE OF BIRTH HIRE DATE TERMINATION DATE NAME DATE OF BIRTH HIRE DATE TERMINATION DATE I need the name in one column and the date of birth in next column followed with hire date and termination date. How can...

Hello I am trying to extract a date of birth date string held in a cell and put it in a standard US date format in a new cell eg 12/21/1903 The date is being held in a text cell in the following format but is some times surrounded by other data DOB-12-21-1903 Bill Married Mary on 10-07-1924...

Hi All, I am hoping someone can help me design a formula for my excel project. THANKS in advance! I am required to calculate the gestational age of a baby (in weeks and days) at a particular point in the pregnancy and also after birth. I have the date of birth of the baby and the gestational...

Is it possible in to make something in word that allows you to enter a date of birth and have it return the age? I was thinking a text box or something similar or being able to copy and paste some cells from a excel worksheet. But in that case, I need the slide bars and navigation bars to be...

Hi I want to create a form which has 2 text boxes for First Name and Last name and one drop down menu which has Year of Birth, so user would enter First, Last and Year of birth and then excel copy that to excel. I know how to do the Text boxes, but not sure if I can do the Drop down menu. Is it...

Hello! I have data formatted like this: <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> 51767 72236 112380 100886 42466 100665 </tbody> The problem is that these are Dates of Birth and I need them to look like: 05/17/67 07/22/36 11/23/80...

Can anyone help me write a macro for a school project I am working on? I think I need to use a MonthName function, I'm not sure how though. The question is: Write a Macro, that will put the employee’s month of birth in column “Birth Month”, for each employee in the database. Month should be in...

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:

I want to calculate the age true date birth with VBA. An example how the date birth is wrote: 196711141893 (the 4 last digits need to be splitted with “-“ so we got 19671114-1893). How to do that firstly true VBA? After that I want it to calculate the age of the persons in range A:A. Im looking...