LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default FORMULA TO FIGURE AGE

"tjsmags" wrote...
Being a football coach I want to figure out how old a child is AS OF
AUG 1 OF THIS YEAR. I have the childrens' birthdates, so what is the
formula to give me their ages AS OF Aug 1, 2007?


Pro or college coaches wouldn't need this, so you seem to be a high school
coach. Don't you have enough fingers & toes?

Seriously,

=DATEDIF(DateOfBirth,"8/1/2007","Y")


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can anyone figure a formula for this?? Please? Bianca Excel Worksheet Functions 2 July 11th 06 06:11 PM
Formula to figure bonus EboniDimplz Excel Worksheet Functions 3 April 19th 06 01:24 AM
Cant figure out formula? oxicottin Excel Worksheet Functions 5 February 21st 06 10:58 PM
Help me I've forgotten the formula and I can't figure it out Santa-D Excel Worksheet Functions 3 February 13th 06 05:19 AM
I can't figure out this formula Steve Excel Discussion (Misc queries) 1 July 15th 05 03:59 PM


All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"