IF formula referencing day of week in cell

[TimeFlies1074]

Reference cell A1 has formula =today(). A1 cell is formatted to display date as Wednesday, August 11, 2021. I need to write a formula that looks at cell A1 and recognizes the day of the week and returns one numerical value if it is a Saturday, and another numerical value if it shows any other day of the week. Thanks in advance for any help.

 

[Fluff]

What version of Excel are you using?
Also what values do you want returned?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[johnny51981]

You can use the WEEKDAY function to do that for you. =WEEKDAY(A1,[Select the Return Type])

 

[Sufiyan97]

Try

for Saturday it will return 1 and for all other days 2

=IF(TEXT(A1,"dddd")="Saturday",1,2)

 

[Fluff]

Another option

=IF(WEEKDAY(A1)=7,1,2)

 

[TimeFlies1074]

What version of Excel are you using?
Also what values do you want returned?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I am using the 2019 version of Excel on WIndows. The values I would like to have returned are 80 if a weekday and 0 if weekend. Thanks!

 

[Fluff]

Thanks for that.
Another option

=80*(WEEKDAY(A1)=7)

 

[Sufiyan97]

As per OP

The values I would like to have returned are 80 if a weekday and 0 if weekend. Thanks!

Thanks for that.
Another option

=80*(WEEKDAY(A1)=7)

Isn't it?

=80*(WEEKDAY(A1)<>7)

 

[Fluff]

It depends on what the op considers a weekend, which I based on the op

one numerical value if it is a Saturday, and another numerical value if it shows any other day of the week

But missed the fact that 80 was for weekday