| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count no of nights between dates | Excel Worksheet Functions | |||
| COUNTIF for numbers of dates in column which are 30 days older than today | Excel Worksheet Functions | |||
| how to count number of days between 2 dates? | Excel Discussion (Misc queries) | |||
| How to subtract 2 dates to get number of days.....please | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
