Microsoft Office Forums - View Single Post - [Solved] help with formulate refers to values

Thread: [Solved] help with formulate refers to values

View Single Post

Old

01-26-2011, 06:36 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

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"

Reply With Quote