I am trying to calculate the days between two dates and time has nothing to do with it.
B3=10/20/2018 // D3=10/30/2018 // e3= =D3-B3 // B3 & D3 are formatted as dates and e3 is formatted as a number and the results in e3=657447 but it should be 10 for 10 days from Oct 20th to Oct 30th.
Some help, please
[Solved] Calculating between two dates
-
usascottwright
- Posts: 11
- Joined: Sat Dec 25, 2010 12:33 am
[Solved] Calculating between two dates
Last edited by robleyd on Fri Oct 19, 2018 12:39 am, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Reason: Tagged [Solved] [robleyd, Moderator]
-
usascottwright
- Posts: 11
- Joined: Sat Dec 25, 2010 12:33 am
Re: Calculating between two dates
Never mind solved, the year wasn't entered correctly. 218 instead of 2018