[Solved] Calculating between two dates

Discuss the spreadsheet application

[Solved] Calculating between two dates

Postby usascottwright » Thu Oct 18, 2018 7:32 pm

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
Last edited by robleyd on Fri Oct 19, 2018 12:39 am, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Scott M. Wright
http://tinyurl.com/3ypy3w6
OpenOffice Version 3 / Wind Vista
usascottwright
 
Posts: 11
Joined: Sat Dec 25, 2010 12:33 am

Re: Calculating between two dates

Postby usascottwright » Thu Oct 18, 2018 7:36 pm

Never mind solved, the year wasn't entered correctly. 218 instead of 2018
Scott M. Wright
http://tinyurl.com/3ypy3w6
OpenOffice Version 3 / Wind Vista
usascottwright
 
Posts: 11
Joined: Sat Dec 25, 2010 12:33 am


Return to Calc

Who is online

Users browsing this forum: Majestic-12 [Bot] and 27 guests