Excel Formula

[Shalve97]

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 

[#2 · Accepted solution]

@Shalve97 

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

[#3]

@Subodh_Tiwari_sktneerthat worked. Thank you very much.

[#4]

@Shalve97 

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.