# Forumla Help

1. ## Forumla Help

Hi Folks,

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?

2. ## Re: Forumla Help

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.

3. ## Re: Forumla Help

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.

4. ## Re: Forumla Help

You have this in Outlook forum....

If the birthday is in A1

=(TODAY()-A1)/365.25
=DATEDIF(A1,TODAY(),"Y")

5. ## Re: Forumla Help

Thank you all so much, very kind

6. ## Re: Forumla Help

You're welcome. Glad we could help.

7. ## Re: Forumla Help

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

8. ## Re: Forumla Help

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
6) Click on "Close this window"

9. ## Re: Forumla Help

I want to add numbers in Two coloum. I am not able to do this.

10. ## Re: Forumla Help

Originally Posted by contactforinfo
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.

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.

11. ## Re: Forumla Help

Thanks see attached

12. ## Re: Forumla Help

Just change 1 to "Y" and 0 to "N" in the formula from post #2.

B2 =IF(DATEDIF(A2,TODAY(),"y")>50,"Y","N")

13. ## Re: Forumla Help

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 )

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1