ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi,
I currently am using this formula to show a '1' in the cell if the date is a Saturday. I now want to amend this so that it identifies Sundays instead. What would I need to change, please?
=IF(VLOOKUP($A5,'All Completed jR - C Bingo'!$A$4:$C$370,2,0)<>"",2,IF(MOD('j C B P - All Dates'!D5,7)=0,1,""))
Thanks in advance.
I currently am using this formula to show a '1' in the cell if the date is a Saturday. I now want to amend this so that it identifies Sundays instead. What would I need to change, please?
=IF(VLOOKUP($A5,'All Completed jR - C Bingo'!$A$4:$C$370,2,0)<>"",2,IF(MOD('j C B P - All Dates'!D5,7)=0,1,""))
Thanks in advance.