Posted to microsoft.public.excel.misc

adelaide

external usenet poster

Posts: 3

Calculating months with half months.

I figured out how to have excel calculate the number of months, but I want to
be able to round off to half months.
So if its 7/15/08 to 10/31/08 I want it to auto calculate 3.5 months.
Or 7/15/08 to 10/15/08 to cound 3 months.
If the value is from July 2-14, to count as .5 if July 15-31 to round down
to 0.
Was hoping this was possible if anyone knows the formula.
Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating months	hotelmasters	Excel Worksheet Functions	3	February 6th 07 03:01 PM
calculating months	DarkNight	New Users to Excel	3	July 24th 06 10:33 PM
Need help calculating months	Baldrick	Excel Discussion (Misc queries)	3	July 10th 06 09:40 PM
Calculating months	pkeegs	Excel Discussion (Misc queries)	5	May 12th 06 03:59 AM
Adding months to dates should account for 28-30-31 day months	Graham	Excel Worksheet Functions	3	February 1st 06 12:06 PM

All times are GMT +1. The time now is 01:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us