Excel Formula

New Contributor

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?


2019-09-25 (1).png2019-09-25 (2).png2019-09-25.png


Any help would be great.



3 Replies


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...


@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies