Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Number of days between two dates
Message
 
À
10/01/2018 15:16:03
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Versions des environnements
Microsoft Office:
Office 2016
OS:
Windows 10
Network:
Windows Server 2012
Divers
Thread ID:
01657081
Message ID:
01657088
Vues:
44
This message has been marked as the solution to the initial question of the thread.
>Instead of using this approach to calculate the number of days between two dates:
>
>=DATEDIF(A1,A2,"m")
>
>Is there a way to include the date value as is instead of A1 and A2?

=DATEDIF("2018/01/01", "2018/01/08", "d")

The format of the date should follow your windows settings, I think, and also you should use "d" not "m" for days (instead of months)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform