Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add 4 months to a date value
Message
From
24/02/2016 10:20:21
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
24/02/2016 00:33:29
Gregory Adam
Belgium
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Re: Add 4 months to a date value
Environment versions
Microsoft Office:
Office 2016
OS:
Windows 8.1
Network:
Windows 2008 Server
Miscellaneous
Thread ID:
01631927
Message ID:
01631962
Views:
43
>Use the formula edate(startdate, numberOfMonths)
>
>looks like
>
>=EDATE(A2,4)
>
Yes, on column 2, I have something like this:

=DATE(YEAR(A1),MONTH(A1)+8,DAY(A1))

So, column 2 is 8 months older than column 1.

But, on column one is the value and that value is 42217. So, directly on that, how can I know what date it is and how can I add directly the number of months on that date?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform