software

Hi, I need some help please. I'm trying to make a schedule with user
prompts. I already have a time part working, but I'm having trouble
with the date part:

Say cell A1 contains a date to be entered by the user viewing the
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' if
the date the user enters in A1 matches the WEEKDAY in B1 or 'NO' if the
dates don't match.

I hope I explained that clearly enough. Thanks for any help!--
silverflameca
------------------------------------------------------------------------
silverflameca's Profile: www.excelforum.com/member.php...oamp;userid=33099
View this thread: www.excelforum.com/showthread...hreadid=529105=IF(WEEKDAY(A1)=B1,quot;YESquot;,quot;NOquot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;silverflamecaquot; gt;
wrote in message
news:silverflameca.25ofmo_1144048208.2856@excelfor um-nospam.com...
gt;
gt; Hi, I need some help please. I'm trying to make a schedule with user
gt; prompts. I already have a time part working, but I'm having trouble
gt; with the date part:
gt;
gt; Say cell A1 contains a date to be entered by the user viewing the
gt; schedule. Another cell, say B1 will always contain a WEEKDAY number,
gt; say 2 for Monday. I want cell C1 to have a formula that says 'YES' if
gt; the date the user enters in A1 matches the WEEKDAY in B1 or 'NO' if the
gt; dates don't match.
gt;
gt; I hope I explained that clearly enough. Thanks for any help!
gt;
gt;
gt; --
gt; silverflameca
gt; ------------------------------------------------------------------------
gt; silverflameca's Profile:
www.excelforum.com/member.php...oamp;userid=33099
gt; View this thread: www.excelforum.com/showthread...hreadid=529105
gt;