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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
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