PC Review


Reply
Thread Tools Rate Thread

Calculate and display year and month

 
 
kenlo
Guest
Posts: n/a
 
      4th Jul 2008
E.g. when Date1 - Date2 = 850 days (=2.33 years), is there a way to display
"2 years 4 months" within one cell? I have figured out the way to display in
2 separate cells.

Thanks
Ken
 
Reply With Quote
 
 
 
 
Teethless mama
Guest
Posts: n/a
 
      4th Jul 2008
=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days"


"kenlo" wrote:

> E.g. when Date1 - Date2 = 850 days (=2.33 years), is there a way to display
> "2 years 4 months" within one cell? I have figured out the way to display in
> 2 separate cells.
>
> Thanks
> Ken

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate Age Year Month & day shailendra joshi Microsoft Excel Misc 3 6th Sep 2008 03:33 PM
calculate year and month =?Utf-8?B?bWljaGVsbGU=?= Microsoft Excel Misc 9 23rd May 2008 08:54 AM
Calculate month & year in between two dates Montu Microsoft Excel Worksheet Functions 2 30th Dec 2007 04:45 AM
Calculate month & year in between two dates Montu Microsoft Excel Worksheet Functions 0 29th Dec 2007 08:19 AM
how to calculate total months from month/year =?Utf-8?B?cGF0dGk=?= Microsoft Excel Misc 1 8th Dec 2004 09:50 PM


Features
 

Advertising
 

Newsgroups
 


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