Thank you so much for sharing this! One thing worth mentioning is that the date formats for the stay dates need to match the date formats for the stay count dates or else the formula doesn’t work. I ran into this issue and kept getting a zero count until I fixed the date formatting to match.
Thank you for the formula! super helpful. I would like to know if I need to subtract 1 day from the end date how I can do it? I am using this for a hotel and technically the last day the customer is not occupying the room. Do you know what I mean?
Could you do this also based on Criteria such as Room name or something like that if so how would you go about doing this? Loved the video and made me understand it
I would also like to know how to do this. I am working on finding absences for different departments. I can say how many absences there were each day across the org using this method, but if I were to be asked the absences for each department, I would have to create a new sheet with only data for that specific department and use the method on this video. We have over 30 departments and I don't have the time to create a report for each one. Appreciate any help on this question.
If I am working on a membership sheet and there is a start date of membership, how can I get the exact date on when is the 4th week, 8th week and so on?
Hi, great video, do you know of a formula that can count the number of entries for a specific time, so for example column A would be the result of the formula. Column A Column B Column C 3 12 Mar 2022 13:30 3 12 Mar 2022 13:30 3 12 Mar 2022 13:30 6 12 Mar 2022 14:00 6 12 Mar 2022 14:00 6 12 Mar 2022 14:00 6 12 Mar 2022 14:00 6 12 Mar 2022 14:00 6 12 Mar 2022 14:00 Thanks :)
The problem that I am coming across is that I want to how many people enrolled during a date range. When I try the formula it is only giving me the answer to the one cell. Which the goal is entering dates on different cells it will give me the how many answer. How do I do that?
Best of the best man I wanna ask you something If I write date 02/04/2021 And the date came is there anyway in excel to make the date 02/05/2021 And make it every month alone I mean I wanna it count one more month alone with out me
Thank you so much for sharing this! One thing worth mentioning is that the date formats for the stay dates need to match the date formats for the stay count dates or else the formula doesn’t work. I ran into this issue and kept getting a zero count until I fixed the date formatting to match.
had 0 hope to find a solution here, but happy to be proven wrong! awesome, thanks a lot!
Glad I could help! 👍
Thank you! Finally you gave me the solution I've been looking for. Greetings from Munich.
You're welcome! Glad I could help Stefan 👍
Thank you for your very clear and accurate description of how to apply this function.
You have made a huge difference!
My pleasure. Thank you Eleanor.
Perfect for a hotel industry, great tip Alan, Thank you!
Cheers
Mohideen
Thank you Mohideen.
Thanks bro, was searching for it since morning...
No worries. Happy to help 👍
You’re a GOAT
Thank you, Daniel.
Reallyhelpful video and helped me solve my issue quickly.
Great to hear. Thank you, Tarik.
Thank you, Thank you, Thank you!!!!!!!!!!
You're very welcome, Melissa.
Great video. Super clean
Thank you 👍
Excellent!
Thank you Dario.
Really Helpful 👍 keep going
Thanks 🙂
Thank you for the formula! super helpful. I would like to know if I need to subtract 1 day from the end date how I can do it? I am using this for a hotel and technically the last day the customer is not occupying the room. Do you know what I mean?
Hi Yeni,
No, this statement doesn't count the second date so you don't need to subtract anything.
In his formula, the second part uses F2
Well done, mate! Saved a life! Cheers!
Thank you so much
You're welcome, Kamala.
How to get the overlapping dates of two date ranges?
Thank you very very much.
You're welcome Farah 😊
Could you do this also based on Criteria such as Room name or something like that if so how would you go about doing this? Loved the video and made me understand it
I would also like to know how to do this. I am working on finding absences for different departments. I can say how many absences there were each day across the org using this method, but if I were to be asked the absences for each department, I would have to create a new sheet with only data for that specific department and use the method on this video. We have over 30 departments and I don't have the time to create a report for each one. Appreciate any help on this question.
Nice
Thank you.
If I am working on a membership sheet and there is a start date of membership, how can I get the exact date on when is the 4th week, 8th week and so on?
Hi, great video, do you know of a formula that can count the number of entries for a specific time, so for example column A would be the result of the formula.
Column A Column B Column C
3 12 Mar 2022 13:30
3 12 Mar 2022 13:30
3 12 Mar 2022 13:30
6 12 Mar 2022 14:00
6 12 Mar 2022 14:00
6 12 Mar 2022 14:00
6 12 Mar 2022 14:00
6 12 Mar 2022 14:00
6 12 Mar 2022 14:00
Thanks :)
Can you help me to count the number of dates in a column consisting of blanks, text, and dates?😀
The problem that I am coming across is that I want to how many people enrolled during a date range. When I try the formula it is only giving me the answer to the one cell. Which the goal is entering dates on different cells it will give me the how many answer. How do I do that?
Does anyone know how I would do this in tableau?
But if end date is empty means till date is active how to count of occupancy, pls help me
Best of the best man
I wanna ask you something
If I write date 02/04/2021
And the date came is there anyway in excel to make the date 02/05/2021
And make it every month alone
I mean I wanna it count one more month alone with out me
how to count a specific date items
I think I have to cancel my subscription. I am too stupid for this channel. :-) Great video.
Thank you Robert. Thank you for being a loyal subscriber.
Will it be the same formula if is time?
Yes that should work. If the time goes from one day to the next you will need the date and time in the cell or cells.
It did work thanks! But how do you it if you are looking for total hours per interval in time ranges?