Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add 4 months to a date value
Message
From
25/02/2016 02:43:49
 
 
To
24/02/2016 13:42:20
General information
Forum:
Microsoft Office
Category:
Excel
Environment versions
Microsoft Office:
Office 2016
OS:
Windows 8.1
Network:
Windows 2008 Server
Miscellaneous
Thread ID:
01631927
Message ID:
01632004
Views:
41
>>OK., should have said that it won't always work
>>
>>Try to add 6 months to 31/08/2015 - that would become 31/02/2016
>
>Well, it still works.
>
>See attached. The date is 31/08/2015. The next cell adds six months to it.


Don't think so

Aug 2015 + 6 months is Feb 2016 not March imo

attached
(1) Your formula - gives 02/03/2016

(2) With edate() - gives 29/02/2016
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform