Righty ho guys, here goes
I am only 15 (as some of you may know) and the cossie in my sig is my fathers, I need to beable to do something in Excel for my IT coursework.
Basicaially, my IT teacher when I suggested something to her said that I could do this I would get a pretty much be guarnteed an A* I need to beable to do an if statment/if and statment to figure make the following:
I I put in a date of birth, take mine for example:
23/11/1988
Then todays date:
16/1/2004
I need it to tell me that this person is 15
ANY help would be greatly appreciated and will go towards my GCSE
PS My IT teacher said it's ok to put it on here cos i'm sure some of you will know!
Thanks a lot for ANY help in advance,
James

 

hello, i dont know! hahaha

 

Thanks a lot alan now fook off this is serious i need to know how top do this or get some idea atleast

 

I've just had a look myself, and typed into the help box "years from dates"
It's all there.
Excel converts dates since 1900 into serial numbers (days, I suspect?)
Good luck

 

go into the tool bar at the top of the screen

then go to the functions buttons, click on DATE & TIME.
the click on YEAR.

this will then covert a given date in to a serial number e.g the year.

if you click ok then it will return the year 1900, all you have to do now is enter your given date in another cell then enter that cells address into the data bit at the 1900 cell.

do that again for the other cell subtract the cell then you get the amount in years.

if this isn,t enought pm me your address and i will copy a sheet to you.

and the the teacher there a twat

 

Nah, the teachers OK she's new and she makes us do the work so I don't care as long as I get the GCSE!
If you could mail me a copy sheet that would be great
Cheers

 

I have a copy ready to send you, but no email address for you
Send me an email and I will reply with your attachment.




I want a share of all your future earnings in return

 

yhm

 

yhm too

 

Smidsy have you worked this out yet? This is how I would do it:

Not sure why you need an =if argument mate? - Only if you wanna not show a zero value if nothing is in your input cell

If you make A1 (substitute $A$1 as necessary or use tools, name, define, and name that sngle input cell) the input cell you put your date of birth in the the, and put the forumla elsewhere, it should be:

=round(sum((today()-$A$1)/365),0)

or to keep answer cell blank until something is in the input cell:

=if($A$1="","",round(sum((today()-$A$1)/365),0))

$A$1 is now an absolute reference and wherever you copy this formula to on the worksheet will still refer to this cell. Use right mouse button and format then date to get how you want the date to appear.

BTW Excel looks at dates by number of days from the date 1st Jan 1900, (on apple macs the date is 1904 for some reason). So if you only have a general format in place and type in todays date it will be something like 38003 I.e. thats how many days from 1/1/1900 it is. Doesn't matter how you format the cell, Excel still looks at the date in number of days - its just how you view it that changes.

This should work - but a haven't got excel at home so can't check. Have fun mate

 

The #NUM you see in boxes D2 and I2 are because no computation has taken place yet!
Input you date of birth into boxes A2, B2, and C2 in the same format as I've inputted yesterday's date into boxes E2, F2, and G2.
Computations will then occur and your age will appear in box I2.
The number you see currently in H2 is the serial date in number format for yesterday's date.

 

Nice one mate

 

Cheers Jamie, I have now 3 different way of doing it therefore will show all 3 to my IT teacher and see what she says
Do you still have the S2? Last I saw of you, you had just got the Focus and you weren't sure if you were keeping it or not