Forum Discussion
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 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
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 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...
=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.
