SOLVED
Home

Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-875177%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875177%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20use%20the%20following%20formula%20but%20am%20unsure%20as%20to%20why%20it%20will%20not%20work%3A%26nbsp%3B%3DIF(D4%3D%22Saturday%22%2C%22Sunday%22%2CINDEX(Weekdays%2CMATCH(D4%2CWeekdays%2C0)%2B1%2C1))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20go%20back%20in%20to%20edit%20the%20formula%20it%20has%20%22Saturday%22%2C%22Sunday%22%2CINDEX%20highlighted%20but%20I%20am%20unsure%20of%20what%20needs%20to%20be%20changed%20in%20order%20for%20it%20to%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133511i58E2ACD413A36F3B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-25%20(1).png%22%20title%3D%222019-09-25%20(1).png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133512iBDE475EC0E2E4F07%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-25%20(2).png%22%20title%3D%222019-09-25%20(2).png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133513i8204ECFB7CC8F551%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-25.png%22%20title%3D%222019-09-25.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-875177%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875214%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415196%22%20target%3D%22_blank%22%3E%40Shalve97%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20formula%20looks%20fine%20and%20it%20should%20work%20without%20an%20issue.%3C%2FP%3E%3CP%3EIt%20seems%20you%20should%20use%20a%20semicolon%20instead%20of%20comma%20in%20the%20formula%20as%20per%20your%20regional%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20and%20see%20if%20that%20works%20for%20you...%3C%2FP%3E%3CP%3E%3DIF(D4%3D%22Saturday%22%3B%22Sunday%22%3BINDEX(Weekdayss%3BMATCH(D4%3BWeekdayss%3B0)%2B1%3B1))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875217%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875217%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3Ethat%20worked.%20Thank%20you%20very%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875247%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875247%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415196%22%20target%3D%22_blank%22%3E%40Shalve97%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%20Glad%20it%20worked%20as%20desired.%3C%2FP%3E%3CP%3EPlease%20take%20a%20minute%20to%20accept%20the%20post%20with%20the%20proposed%20solution%20as%20a%20Best%20Response%2FAnswer%20to%20mark%20your%20question%20as%20Solved.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Shalve97
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.

 

Thanks 

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

@Subodh_Tiwari_sktneerthat worked. Thank you very much.

 

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

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