Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of days between two dates
Message
 
To
10/01/2018 15:16:03
General information
Forum:
Microsoft Office
Category:
Excel
Environment versions
Microsoft Office:
Office 2016
OS:
Windows 10
Network:
Windows Server 2012
Miscellaneous
Thread ID:
01657081
Message ID:
01657088
Views:
45
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform