convert 3months and 15 days into 3.5

Catalin.B · #1 09-02-2011, 01:24 AM

Here is an idea to play with:

=IF(DATEDIF(I8;G8;"m")=0;"";DATEDIF(I8;G8;"m"))+IF(DATEDIF(I8;G8;"md")<15;0;1)&" months"

It will add 0 months to the initial month calculation if the days number are <15, and add 1 month if days are>=15
instead of the above formula, you can use:
=IF(DATEDIF(I8;G8;"m")=0;"";DATEDIF(I8;G8;"m"))+CE ILING(DATEDIF(I8;G8;"md")/30;0,5)&" months"
to get decimal results...and so on

Change ; with , to match your local settings

caz46 · #2 09-02-2011, 09:17 AM

That's great and works perfectly. Thanks very much.

Catalin.B · #3 09-05-2011, 02:45 AM

Great... Than you can mark your thread as solved, for users with same problems...

caz46 · #4 09-05-2011, 03:23 AM

Quote:

Originally Posted by Catalin.B

Great... Than you can mark your thread as solved, for users with same problems...

I can't see where I can do that?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Master Projects with different Working Days	Philip.Skeet	Project	2	08-19-2011 09:45 AM
Dynamic Filter 15 days lookout.	stct	Project	5	05-20-2011 03:30 AM
Non-Working Days on Gantt	JayTT	Project	1	01-28-2011 05:42 AM
Conditional formatting of Today +21 days?	SHERMAN	Excel	3	12-20-2010 08:08 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM