help with formulate refers to values

meninio · #1 01-26-2011, 05:45 AM

It would be like this:

DATEDIF = (TODAY (), 'end date)

?

Colin Legg · #2 01-26-2011, 06:01 AM

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")

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