Help with DATEDIF Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Help with DATEDIF Formula

01-12-2012, 06:57 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Help with DATEDIF Formula

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Using your current formula as a basis, this seems to give the results you want:

Code:

=IF(DATEDIF(MAX(A4,$D$2),B4,"m")=0,"",
    DATEDIF(MAX(A4,$D$2),B4,"m"))+
    CEILING(DATEDIF(MAX(A4,$D$2),B4,"md")/30,0.5)&""

Where D2 has either of these formulae which calculate the 1st day of the next month from today's date:

Code:

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)
 
or
 
=EOMONTH(TODAY(),0)+1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help with a look up or if formula	beb1227	Excel	3	12-31-2011 01:08 PM
help with formula?	doczilla	Excel	2	09-25-2011 04:14 PM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM
Help for formula	dehann	Excel	5	05-01-2009 10:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 PM.