Forum Discussion
Solved
Excel Formula
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 i...
Your 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))
Subodh_Tiwari_sktneerthat worked. Thank you very much.
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.