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:01 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

Almost. Please see attached example, based on the spreadsheet that was attached on the other thread.

Code:

=IF(B2>C2,
    DATEDIF(C2,B2,"m")&" months "&DATEDIF(C2,B2,"md")&" days",
    "0 days")

Attached Files

UsingDATEDIF.xls (13.5 KB, 18 views)

Reply With Quote