Excel formula to ifentify if a date is a Tuesday or a Thursday

[phillipcook]

Hi guys

in my spreadsheet I have site visit days, I need create a formula that goes as follows:

=if(and(A1=“site”,or(B1=“Task1”,B1=“Task2”),if(C1(column with the dates in custom format “dddd, dd-mmm-yyyy”)=(need the formula to identify if the date is a Tuesday or a Thursday),0.5,1,)””))

thanks in advance.

 

[rabindrawithu]

Hi guys

in my spreadsheet I have site visit days, I need create a formula that goes as follows:

=if(and(A1=“site”,or(B1=“Task1”,B1=“Task2”),if(C1(column with the dates in custom format “dddd, dd-mmm-yyyy”)=(need the formula to identify if the date is a Tuesday or a Thursday),0.5,1,)””))

thanks in advance.

You can use IF(C1=Weekday(3) or C1=Weekday(5)..then