Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shan
 
Posts: n/a
Default how do i calculate age in term of years, months, days

how do i calculate age in term of years, months, days
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default how do i calculate age in term of years, months, days

put =TODAY() in A1
put your birthday in B1
and put

=DATEDIF(B1,A1,"y") & " years, " & DATEDIF(B1,A1,"ym") & " months, " &
DATEDIF(B1,A1,"md") & " days"

in C1
--
Gary''s Student


"shan" wrote:

how do i calculate age in term of years, months, days

Reply
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
how do I convert a number to number of years, months and days because Excel Worksheet Functions 2 October 12th 05 06:15 PM
Months or Years remaining, formatting James C Excel Discussion (Misc queries) 3 September 20th 05 10:38 PM
Formula that will represent years & months worked Pam Excel Discussion (Misc queries) 5 August 29th 05 11:20 PM
Calculate months and years Ned Ludd Excel Discussion (Misc queries) 5 December 10th 04 02:57 PM
How do I display months and years between two dates JSmith Excel Discussion (Misc queries) 1 November 30th 04 05:41 PM


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

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

About Us

"It's about Microsoft Excel"