Date Calculation

		Microsoft Office Forums > Microsoft Excel > Excel
Date Calculation

FAQ

Thread Tools

Display Modes

04-17-2012, 01:04 PM

Pecoflyer

Windows 7 64bit Date Calculation

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=IF(DATEDIF(A1,A2,"y")=0,"",DATEDIF(A1,A2,"y")&" years ")&IF(DATEDIF(A1,A2,"ym")=0,"",
DATEDIF(A1,A2,"ym")&" months ")&DATEDIF(A1,A2,"md")&" days"

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculation of start date	ketanco	Project	1	02-29-2012 07:01 AM
Formula calculation	danbl	Excel	8	02-23-2012 04:35 AM
Calculation within Cells	manich1	Excel	2	12-07-2011 02:59 PM
Excel Calculation Problem	UnholySmoke	Excel	2	09-14-2011 08:15 AM
Help with 'hours worked' calculation...	Snvlsfoal	Excel	1	08-11-2011 05:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:41 AM.