Hi there and thanks for the warm welcome.
I have been trying to figure out this myself before coming to ask for help as I want to learn but everything I do returns 0.
I have tabs January through to December and in each tab we will have a row that will contain different dates in that row. On a separate tab, I have a calendar which I want to count the number of times that date shows.
For example,
Would return on my other tab
The formula I am using is (this is only looking for the 1st Jan, I would need to repeat the code in the box that looks for the 2nd)
Which is returning 0. Obviously not right. FYI, there are multiple rows that the formula would need to check.
Where am I going wrong? Hope this makes sense
Thank you so much
I have been trying to figure out this myself before coming to ask for help as I want to learn but everything I do returns 0.
I have tabs January through to December and in each tab we will have a row that will contain different dates in that row. On a separate tab, I have a calendar which I want to count the number of times that date shows.
For example,
| Date of Operation (DD/MM/YYYY) | 01/01/2024 | 04/01/2024 | 03/01/2024 | 01/01/2024 | 02/01/2024 |
Would return on my other tab
| Mon | Tue | Wed | Thur | Fri | Sat | Sun | |||||||
| 1st | 2 | 2nd | 1 | 3rd | 1 | 4th | 1 | 5th | 0 | 6th | 0 |
The formula I am using is (this is only looking for the 1st Jan, I would need to repeat the code in the box that looks for the 2nd)
Excel Formula:
=COUNTIFS(January!14:14,1/1/24,January!32:32,1/1/24,January!50:50,1/1/24,January!68:68,1/1/24,January!86:86,1/1/24)Which is returning 0. Obviously not right. FYI, there are multiple rows that the formula would need to check.
Where am I going wrong? Hope this makes sense
Thank you so much
