View original (French)

Calculation of number of nights for guest rooms

Solved
JCD22580 Posted messages 5 Status Member -  
JCD22580 Posted messages 5 Status Member -
Hello,

I created an Excel file with a column for the arrival date of our clients and the departure date, and the result is displayed in another column which allows me to perform additional calculations, so far so good.
However, I sometimes have an arrival on 28/07 and a departure on 5/08, and the result does not match the required calculation: 8 instead of 9?
I used the DAYS360 function, but I need to count 365 days... so I have to manipulate my result cell by adding the actual total...
Can someone help me?
Thank you in advance.
Best regards to all.
JCD

<config>Windows 7

4 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    =B2-A2-1
    set the cell to Standard format.

    eric

    --
    By continually trying, we eventually succeed. So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to saying thank you (yes, it’s a thing!!!), remember to mark it as resolved. Thank you.
    0