Sep 25 2019 11:04 AM - edited Sep 25 2019 11:14 AM
Hi, I am trying to use the following formula but am unsure as to why it will not work: =IF(D4="Saturday","Sunday",INDEX(Weekdays,MATCH(D4,Weekdays,0)+1,1))
When I go back in to edit the formula it has "Saturday","Sunday",INDEX highlighted but I am unsure of what needs to be changed in order for it to work?
Any help would be great.
Thanks
Sep 25 2019 11:21 AM
SolutionYour formula looks fine and it should work without an issue.
It seems you should use a semicolon instead of comma in the formula as per your regional settings.
Try this and see if that works for you...
=IF(D4="Saturday";"Sunday";INDEX(Weekdayss;MATCH(D4;Weekdayss;0)+1;1))
Sep 25 2019 11:40 AM
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.
Sep 25 2019 11:21 AM
SolutionYour formula looks fine and it should work without an issue.
It seems you should use a semicolon instead of comma in the formula as per your regional settings.
Try this and see if that works for you...
=IF(D4="Saturday";"Sunday";INDEX(Weekdayss;MATCH(D4;Weekdayss;0)+1;1))