dob

Hello. I'm fairly new with VBA. I have data that is more of a vertical format, but I need to move it to a new worksheet, and put all of the data for one patient on a single row. Please look at the following data example to understand my explanation. Each new patient record always starts with...

Hi all! I was wondering if someone could please give me hand with a, probably very simple, formula. I am about to circulate a worksheet to a few organisations my my office deals with, asking them to enter some standard details of their clients (First Name, Surname, DOB, Age...). I have set up...

=IF(AL2="",AND(OR(S2="IN",S2="KY",S2="HI",S2="WV")*TODAY()-N2/365)) Above is the formula I wrote to calculate less than 18 years for particular states. This is what I a trying to achieve and not sure how to go about it. Column AL has ID Column S has States Column N has DOB Column AE has...

Both of these formulas are working (no errors) but not quite up to the standards that I want for the workbook. The first formula looks at a DOB on worksheet ‘personal_info’!E12 and if it’s blank, returns a blank. Otherwise, it will return a ‘year’ that is based on the DOB of the user. If...

Hi Mr. Excellers, I am working on a personal project where I am making a excel sheet, where I want to calculate Life numbers from the Day of birth of persons, based on the book of Dann Millman "The life your where born to live". It goes as follow; you take a DOB and you count the loose numbers...

Hi - hoping some expert can help me with a text search query I've got a column full of text entries. What I would like to do is extract x number of characters after certain keywords. So for example. keyword 'DOB: ' then bring back the next 10 characters So if the below is the text in cell...

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...

I am working on a sheet that will have columns Name 1, DOB 1, Age 1, Relationship 1, Name 2, DOB 2, Age 2..... up to 24 total. Info will be entered with a Userform.... and not every row will be filled with 24 people Form Uses the following code for each of the people 'Adult 1...

Hello All, I am sort of new to VBA and have a very specific macro requirement I need some help with, hopefully I can explain it well. 1. Column A & B has around 1000 lines of data (maybe much more) that contains blank/crappy data and valid data 2. Column A has a persons name 1 cell above the...

Hi Everyone, I have a report generated from another program. It's giving me all of the information I need, it just not in a usable table form. I will try to explain. This is what a single employee record looks like. <tbody> A B C D E F G H 1 Name: John Doe 2 Employee ID: 1234...

Hi all, I have the DOB off my students and need to work out their age on a specific date. So for example DOB: 01/01/2006 and I want to know how old they would be on 12/10/2018? Can this be done? As I have many students all different ages? Thanks

I am implementing some error checking in a form and want to ensure that the user cannot put in dates that are in the future or where Session Date is before DOB...here's my code: If CDate(SessionBox.Value) > Format(Date$, "dd/mm/yyyy") ThenMsgBox "Session Date cannot be in the future, please...

I have the following code: Private Sub CommandButton1_Click() With DOBTextBox .Value = dDate .NumberFormat = "dd/mm/yyyy" End With End Sub Private Sub DOBTextBox_Exit(ByVal Cancel As MSForms.ReturnBoolean) With Me.DOBTextBox If Len(.Text) > 0 Then...

Hi, I have the date of joining of the employees. I need to calculate their tenure in years and months. Ex. DOB: 01.01.2014. Can anyone help me.

Hi All, i am getting a error sub or function not defined in vba, can any one help. Sub xyz() counter = 1 Sheets("Sheet3").Select For k = 6 To 200000 DOBval = Cells(k, 1) If Mid(DOBval, Find("", DOBval + 1, 6)) = "App.No" Then DOB = Cells(k + 1, 1) counter = counter + 1...

I need to check if the data in the cells A to D are complete and correct for all the sheets in excel and get the output populated in a separate sheet. <tbody> A B C D Name Age DOB Date of graduation </tbody> Can I use Excel VBA code for this? If yes, what would be the code? Thanks in...

I am very novice with VBA and have adapted what I would like to do from code on this forum and the internet. It all works except for if you click No on the "GO" part. I cannot figure out what is happening and would appreciate any help. Craig Sub CorpsChiefUpdate() Dim GO As Integer Dim...

Hi all, I want to make a simple database - I already have a list of User ID's in Column A. I would like clients to enter their User ID in F1, DOB in G1 and Location in H1. I would like to add a macro button where once clicked, it should look for the User ID and paste DOB and Location in to...

I'm really new to Excel. Here's my challenge: 2 spreadsheets with the exact same headers and a unique identifier (phone number) Spreadsheet #1 has 5 complete entries for all columns LName, FName, DOB, Phone#, Make, Model Spreadsheet #2 has only Phone# completed and missing all other info...

Hey All, First time posting. I have a problem with a table I'm trying to create. I have Age Groups as listed below, and I have a list of DOBs in another table. I've been trying to use a COUNTIF but can't seem to get the age range right for each cell in the Age Groups table. Any help...