VLOOKUP AND MOD - Formula to identify Sundays

[ollyhughes1982]

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.

 

[BenMcBen]

use weekday() instead?

 

[ollyhughes1982]

use weekday() instead?

What would that look like within that formula? I was hoping there was just something simple I could tweak to change it to find Sundays, rather than Saturdays. This was a formula given to me by someone else and not sure how it actually identifies Saturdays.

 

[BenMcBen]

if(weekday(A1) = 1 ,true,false)

(by default - other flags are available please see the help for weekday()

 

[ollyhughes1982]

if(weekday(A1) = 1 ,true,false)

(by default - other flags are available please see the help for weekday()

Great. Thanks for your help.