countif number of nights not days using dates
 

I am trying to count no of nights (not days) for example stayed in a hotel,

For example
You put in the dates in row 1 (A:AA)
Fill then row 2 (A:AA)with "x" if stayed at hotel

Need then another cell to calculate the number of nights that has been
stayed at the hotel (the cells filled with "x").

eg. I need the number of nights between the dates, eg 3 days = 2 nights
between 11th March - 13th March.

Can anyone help?

In advance thanks for your help

countif number of nights not days using dates
 

A1 A2
11th March - 13th March

then =A2-A1 returns 2 (nights if you like). Number of days would be =A2-A1+1

Regards,
Stefi

€žMorten€� ezt Ã*rta:


I am trying to count no of nights (not days) for example stayed in a hotel,

For example
You put in the dates in row 1 (A:AA)
Fill then row 2 (A:AA)with "x" if stayed at hotel

Need then another cell to calculate the number of nights that has been
stayed at the hotel (the cells filled with "x").

eg. I need the number of nights between the dates, eg 3 days = 2 nights
between 11th March - 13th March.

Can anyone help?

In advance thanks for your help