rfletcher35
Active Member
- Joined
- Jul 20, 2011
- Messages
- 300
- Office Version
- 365
- Platform
- Windows
Hi Guys,
I have a column that provides me with a day eg Mon, Tue etc from a particular date using the formula -
=IF(B2="","",DAY(AB2))
The problem is when I try to count how many "Mon" are in that column, I need to do this for all days of the week.
This is a section of my list as I have the cell formatted to 'DDD'
So really I need something like countif column AQ="Mon" for example but clearly that doesn't work
Can some help me please?
Thanks
Fletch
I have a column that provides me with a day eg Mon, Tue etc from a particular date using the formula -
=IF(B2="","",DAY(AB2))
The problem is when I try to count how many "Mon" are in that column, I need to do this for all days of the week.
Day |
Sun |
Mon |
Mon |
Tue |
Tue |
Wed |
Wed |
Wed |
Wed |
Wed |
Wed |
This is a section of my list as I have the cell formatted to 'DDD'
So really I need something like countif column AQ="Mon" for example but clearly that doesn't work
Can some help me please?
Thanks
Fletch