Forum Discussion

excel101's avatar
excel101
Copper Contributor
Jun 21, 2019
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 ...
Formulas and Functions
excel101's avatar
excel101
Copper Contributor
Jun 24, 2019

Twifoo Twifoo Thank you! Can you elaborate a bit further please. I have used the same formula but it just not working. What do you mean by "data layout" exactly? Do mind looking at the attachment with the new set of dates and the formula please? Thank you again.

  • excel101's avatar
    excel101
    Copper Contributor
    Jun 24, 2019

    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!

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 24, 2019

      excel101 

       

      Perhaps you didn't fix the row with absolute reference or like. Most probably wrong combination of absolute/relative references in pasted formulas.

Resources