# Data in columns formula to generate a new column

Discussion in 'Business Applications' started by AR22, Nov 6, 2012.

Thread Status:
Not open for further replies.
1. ### AR22Thread Starter

Joined:
Nov 6, 2012
Messages:
1
Hi all,

I am using the below formula (that I found on this forum) to calculate the age based on a DOB. I now want to create a formula for the next column to have either Yes or No if the age is above a certain value.

If this is possible, is it then possible if I have two ages in separate columns to generate a Yes if either of the ages are above the specified Value?

Formula for Age Calculation;
=DATEDIF(\$C24,NOW(),"y") & "y,"&DATEDIF(\$C24,NOW(),"ym") & "m,"& DATEDIF(\$C24,NOW(),"md") & "d"

Any help would be greatly appreciated,

Many thanks.

2. ### etafModerator

Joined:
Oct 2, 2003
Messages:
64,749
First Name:
Wayne
try this

=IF (Cell you do the calculation in > age you want to test , "Yes" , "No" )

if you want to test two columns , then

=IF ( OR(column1 > age, column2 > age ), "Yes", "No")

can you load a dummy spreadsheet and we can check the above works OK

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1075657