help with formulate refers to values

		Microsoft Office Forums > Microsoft Excel > Excel
help with formulate refers to values

01-26-2011, 06:36 AM

Colin Legg Colin Legg is offline

Windows 7 32bit help with formulate refers to values

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

DATEDIF() can't handle an end date earlier than the start date, so I think you would have to arrange the formula like this:

Code:

=IF(B2<TODAY(),"- ","")&
    DATEDIF(MIN(B2,TODAY()),MAX(B2,TODAY()),"m")&" months "&
    DATEDIF(MIN(B2,TODAY()),MAX(B2,TODAY()),"md")&" days"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulate month in Excel 2010	meninio	Excel	4	01-25-2011 12:13 PM
Drag Button which refers to the active Word document to Explorer	DRob	Word	0	10-03-2010 06:40 AM
Using Conditions to Add Values	EclipticalD	Excel	1	07-08-2010 09:50 PM
Opening .pst with dummy values	ran_sushmi	Outlook	0	08-19-2009 01:56 AM
Fields controlled by List box values	farfromapro	Word	0	02-11-2009 02:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:01 PM.