I have a basic shipping excel spreadsheet, in column A I have dates, and in column B I would like it to show when I can ship as there's a processing hold.
So if the day of the week from column A is Saturday, Sunday, Monday or Tuesday then it displays Friday, but if its Wednesday, Thursday or Friday it would display Wednesday.
I know this should be simple but i just can't get the IF query to work. Please help.
Thanks in advance.
Try this:
=IF(WEEKDAY(A1,16)<5,"Friday","Wednesday")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks your assistance, unfortunately that didn't work. Any other suggestions?
What do you mean? It works here:
Excel 2016 (Windows) 32 bit
Wednesday B1: =IF(WEEKDAY(A1,16)<5,"Friday","Wednesday")
Sheet: Sheet1
Provide a sample workbook, please. Maybe your dates are just text and not dates at all?
My apologies, user error my end, worked perfectly once I typed it in correctly.
Is there anyway to modify the formula that if A1 is empty, B1 will be blank?
Yes, easily:
=IF(A1="","",IF(WEEKDAY(A1,16)<5,"Friday","Wednesday"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks