Nevermind, I worked everything out! But now I'm not sure how to delete this help post...
Nevermind, I worked everything out! But now I'm not sure how to delete this help post...
Last edited by silverflameca; 04-03-2006 at 03:49 AM.
=IF(WEEKDAY(A1)=B1,"YES","NO")
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"silverflameca" <[email protected]>
wrote in message
news:[email protected]...
>
> 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:
http://www.excelforum.com/member.php...o&userid=33099
> View this thread: http://www.excelforum.com/showthread...hreadid=529105
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks