S
silverflameca
Hi, I need some help please. I'm trying to make a schedule with use
prompts. I already have a time part working, but I'm having troubl
with the date part:
Say cell A1 contains a date to be entered by the user viewing th
schedule. Another cell, say B1 will always contain a WEEKDAY number
say 2 for Monday. I want cell C1 to have a formula that says 'YES' i
the date the user enters in A1 matches the WEEKDAY in B1 or 'NO' if th
dates don't match.
I hope I explained that clearly enough. Thanks for any help
prompts. I already have a time part working, but I'm having troubl
with the date part:
Say cell A1 contains a date to be entered by the user viewing th
schedule. Another cell, say B1 will always contain a WEEKDAY number
say 2 for Monday. I want cell C1 to have a formula that says 'YES' i
the date the user enters in A1 matches the WEEKDAY in B1 or 'NO' if th
dates don't match.
I hope I explained that clearly enough. Thanks for any help