Forum Discussion
Excel Formula
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))
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.