Hi Folks,
Need some help, please.
I need a formula. I have loads of people date of births, and what I require is which ones are over 50 years of age. How would i calculate this please?
Hi Folks,
Need some help, please.
I need a formula. I have loads of people date of births, and what I require is which ones are over 50 years of age. How would i calculate this please?
Hello and welcome to the forum.
You haven't given us much to go off of so naturally our answers may not be exactly what you are expecting.
That being said, with birth dates in column A starting in A2, you can use this in B2: =IF(DATEDIF(A2,TODAY(),"y")>50,1,0)
Then drag the formula down column B.
Now you can then use a formula like this =SUM(B:B) to count the number of people that are over 50.
If you want to get it with a single formula, you can use this:
=SUMPRODUCT(--(DATEDIF(A2:A100,TODAY(),"y")>50))
Just adjust the range as needed.
You have this in Outlook forum....
If the birthday is in A1
=(TODAY()-A1)/365.25
=DATEDIF(A1,TODAY(),"Y")
Last edited by davesexcel; 10-11-2018 at 08:33 AM.
Thank you all so much, very kind
You're welcome. Glad we could help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Doh cant get any to work! Bascially if someone is over 5- i like the formula to say YES. For example if DOB is greater than 50 = yes
I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.
To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"
I want to add numbers in Two coloum. I am not able to do this.
Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Thanks see attached
Just change 1 to "Y" and 0 to "N" in the formula from post #2.
B2 =IF(DATEDIF(A2,TODAY(),"y")>50,"Y","N")
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optional )
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks