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
IF statements and conditional formatting
clare1981 in Excel on
0 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
4 Replies