Hi,
I have a list of different dates for an entire year and I want to create an IF function dependant on what day of the week it is.
i.e. if it is Monday the 24th or Monday the 16th the function should only be based on the day of the week and not the date.
Any help on this would be excellent.
Cheers.
=if(weekday(A1,x),true,false)
Where x is number of day of week.
eg 1 = Sunday
Hi,
I tried this but it doesn't differentiate between the days. See attached spreadsheet.
https://www.dropbox.com/s/ee6yqt8dxp0qfte/dates.xlsx
Thanks
Hi,
Do not upload your workbook in file sharing sites. Instead you can upload your sample workbook along with your post.
To attach a file to your post,
Click Advanced (next to Quick Post),
Scroll down until you see "Manage files",
Click that button and select "Add Files" (Right Top Corner).
Click "Select Files" browse your file, Click "Open", Click "Upload", Click "Done" at bottom right. Click "Submit Reply"
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
You should use it like this.....
This formula checks if weekday is 2 (Monday), it returns True otherwise False.
Please Login or Register to view this content.
Does this help?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
okay yeah. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks