Dayweek Help

[bignate1]

So I have a date formatted as MM/DD/YY and I need to determine the day of the week using the MOD function and a single IF Statement and I have no idea how to do this? Any help would be appreciated. Also the date I chose was 3/16/2016

 

[AlphaFrog]

Weekday (Sunday, Monday, ...Saturday) of a date in cell A1
=TEXT(A1,"dddd")

Weekday (1,2,3...7) of a date in cell A1
=WEEKDAY(A1)

I don't know what you want to do with the MOD and IF functions.

 

[bignate1]

Yeah me either. The problem says "Your task is to place the day of the week in BOTH cells C1 and D1 as indicated: For cell c1, determine the day of the week using the MOD function and a single IF statement. For cell d1, determine the day of the week using the WEEKDAY function and a lookup table." I was able to do the weekday function I just have no idea about the other one. Thanks for your help.

 

[Joe4]

Homework problem, eh?
We typically do not like to do people's homework for them.