Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add 4 months to a date value
Message
De
24/02/2016 13:08:15
 
 
À
24/02/2016 12:44:40
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Versions des environnements
Microsoft Office:
Office 2016
OS:
Windows 8.1
Network:
Windows 2008 Server
Divers
Thread ID:
01631927
Message ID:
01631968
Vues:
39
>(1) Your formula is not very good. If the day is 31, if won't work

The current value is 01/08/2015. I changed that for 31/08/2015. I did not have any problem.

>(2) that value is 42217. So, directly on that, how can I know what date
>Rightclick cell - format - take Date. That will make it display a date

That works, thanks.

>(3) how can I add directly the number of months on that date
>
>In the same cell ? Say 8 months
>
>=edate(42217, 8)
>
>
>
>In another cell - say 42217 is in cell A2
>
>=edate(A2, 8)
>
Very good, thanks
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform