Posted to microsoft.public.excel.worksheet.functions

Trev[_2_]

external usenet poster

Posts: 32

Adding .45 months to a date

I have a project estimation worksheet where I am calculating the number of
months remaining, then adding the current date + Months using
=DATE(YEAR(C11),MONTH(C11)+H11,DAY(C11)) where C11 is the current date and
H11 is the number of months expressed at a number. It works fine when the
month field is 1. When the month field is <1 it totally ignores it and the
result ends up being = the start date. Is this "By Design" or a bug?

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
Adding months to a date	miss misty	Excel Worksheet Functions	3	April 13th 07 01:59 AM
Adding 6 Months to a Date	Excel User	Excel Worksheet Functions	8	January 25th 07 12:16 AM
Adding 6 months to any given date	hoyt	New Users to Excel	7	July 9th 06 11:14 AM
adding months to an inputted date	BLW	Excel Discussion (Misc queries)	5	June 9th 05 03:26 AM
Excel Adding years or months to a date	Joan	Excel Discussion (Misc queries)	2	April 25th 05 08:09 PM

All times are GMT +1. The time now is 06:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us