I was just wondering if you could help. I need to display results based on day of the week. The cells contains date format with the following type: Wednesday, March 14, 2012. I need to return the result with the following logic. If date contains Monday or Tuesday, display Yes, otherwise, No.
Assuming dates are NUMBERS (not TEXT) which start in A2 ... Paste this in B2 and copy down:
=IF(WEEKDAY(A2,2)<3,"YES","NO")
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Last edited by leelnich; 08-04-2017 at 09:34 PM.
I also need the same for Monday, Wednesday and Friday. Any ideas?
Adapt leelnich's formula
=IF(OR(WEEKDAY(A2,2)={1,3,5}),"YES","NO")
Dave
Looks like you've got it. However, for the sake of completeness, if your dates WERE text, this would work:
=IF(OR(LEFT(A2,3)={"Mon","Tue"}),"YES","NO")
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Last edited by leelnich; 08-04-2017 at 08:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks