Forum Discussion
Solved
Date calculation formula needed for daily pickup
Hello Experts, I am looking for a formula that calculates daily numbers from check-in and check-out dates. I am aware of the basic formula that calculates the total number of days between two dates ...
SergeiBaklanThank you so much!
Formula works (attached), what exactly is wrong?
SergeiBaklanThank you! One thing I noticed is that when I copied the dates and formula that you sent back and pasted into a new spreadsheet, the formula did not work. But when I re-typed one of the check-in/check-out dates the formula worked all of a sudden. It's like the the dates were not recognized until I re-typed them manually. Do you know what that could be? Thanks again!