SOLVED

Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1202790%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1202790%22%20slang%3D%22en-US%22%3Eis%20there%20an%20attachment%20and%20I'm%20not%20seeing%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1202819%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1202819%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20there%20was%20an%20attachment.%20anyways%2C%20please%20check%20now!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1202770%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1202770%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20prepared%20a%20calender%20of%20my%20visit%20in%20the%20attached%20excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20meet%20my%20brokers%20on%20every%207th%20day.%20I%20have%20a%20column%20called%20posting%20date%20where%20in%20i%20enter%20the%20day%20i%20met%20the%20broker%20in%20cell%20G2%20(please%20refer%20the%20comment%20on%20G2%20Cell).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20help%20i%20have%20to%20present%20this%20to%20my%20boss%20on%20monday.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20please%20NO%20VBA%20or%20Macros.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1202770%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1206462%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206462%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566622%22%20target%3D%22_blank%22%3E%40rakeshtalwar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20the%20attached%20file%20with%20Non%20VBA%20Solution%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%20image-alt%3D%22Snag_6af8ceb.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F174686i26645CC38D3CFF2A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Snag_6af8ceb.png%22%20alt%3D%22Snag_6af8ceb.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%20%7C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelexciting.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ewww.ExcelExciting.com%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1206585%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206585%22%20slang%3D%22en-US%22%3E%3CP%3EAmazing%20bro....%20this%20was%20way%20to%20complex%20and%20you%20cracked%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20go%20through%20this%20and%20i%20am%20sure%20i%20will%20have%20some%20doubts%2C%20please%20help%20me%20solving%20them%20if%20i%20may%20have.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20there%20is%20anything%20i%20do%20or%20i%20can%20be%20of%20any%20help%20to%20you.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ERakesh%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1206600%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1206600%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566622%22%20target%3D%22_blank%22%3E%40rakeshtalwar%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20the%20reason%20%3CSTRONG%3EExcel%20Exciting%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-big-eyes%22%20title%3D%22%3Agrinning_face_with_big_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3BOfficial%20Answer.%3C%2FFONT%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-media-snippet-container%20lia-component-media-snippet%20lia-component-message-view-widget-media-snippet%22%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%20%7C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelexciting.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ewww.ExcelExciting.com%3C%2FA%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22AddMessageTags%20lia-message-tags%20lia-component-message-view-widget-tags%22%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208451%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3Bthere%20is%20some%20additional%20changes%20to%20what%20you%20just%20creaked%2C%20making%20it%20lil%20more%20complex.%20Will%20you%20be%20able%20to%20help%20or%20am%20i%20asking%20for%20too%20much.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW%20i%20am%20big%20time%20follower%20of%20ms.%20Leila%20gharani%26nbsp%3B%20and%20i%20was%20surprised%20to%20see%20both%20of%20your%20video%20on%20your%20blog.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGret%20Going%20man!%20keep%20the%20good%20work!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3ERakesh%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1216240%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1216240%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566622%22%20target%3D%22_blank%22%3E%40rakeshtalwar%3C%2FA%3E%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20feel%20free%20to%20ask%20your%20query%2C%20you%20can%20add%20your%20query%20into%20the%20new%20post%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22lia-media-snippet-container%20lia-component-media-snippet%20lia-component-message-view-widget-media-snippet%22%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22AddMessageTags%20lia-message-tags%20lia-component-message-view-widget-tags%22%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1384199%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1384199%22%20slang%3D%22en-US%22%3EHello%20help%20my%20name%20is%20t%C3%BCrki%C5%9Fh%3CBR%20%2F%3EExcelde%20bu%20form%C3%BClde%20takildim%20yard%C4%B1m%20edin%3CBR%20%2F%3EForm%C3%BCl%20bu%3A%2050%20%C3%9CZERI%20NOT%20SAYISI%3CBR%20%2F%3Ebunu%20hangi%20form%C3%BClle%20bulmam%20laz%C4%B1m%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1977518%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1977518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566622%22%20target%3D%22_blank%22%3E%40rakeshtalwar%3C%2FA%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20file%20with%20a%20simple%20solution%20to%20your%20problem.%20You%20can%20check%20it%20and%20let%20me%20know%20if%20you%20have%20any%20queries.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All,

 

I have prepared a calender of my visit in the attached excel file.

 

I have to meet my brokers on every 7th day. I have a column called posting date where in i enter the day i met the broker in cell G2 (please refer the comment on G2 Cell). 

 

please help i have to present this to my boss on monday. 

 

and please NO VBA or Macros.

9 Replies
is there an attachment and I'm not seeing it?

Yes, there was an attachment. anyways, please check now!

Hi @rakeshtalwar 

 

Please the attached file with Non VBA Solution

 

Snag_6af8ceb.png

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

If you find the above solution resolved your query don't forget mark as Official Answer.

Amazing bro.... this was way to complex and you cracked it.

 

I will go through this and i am sure i will have some doubts, please help me solving them if i may have. 

 

Please let me know if there is anything i do or i can be of any help to you. 

 

Thanks @Faraz Shaikh 

 

Regards,

Rakesh 

 

 

Best Response confirmed by rakeshtalwar (Occasional Contributor)
Solution

Hi @rakeshtalwar

 

That the reason Excel Exciting

If you find the above solution resolved your query don't forget mark as Official Answer.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

If you find the above solution resolved your query don't forget mark as Official Answer.

@Faraz Shaikh there is some additional changes to what you just creaked, making it lil more complex. Will you be able to help or am i asking for too much. 

 

BTW i am big time follower of ms. Leila gharani  and i was surprised to see both of your video on your blog.  

 

Gret Going man! keep the good work!

 

Thanks 

Rakesh 

Hi @rakeshtalwar;

 

Please feel free to ask your query, you can add your query into the new post

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

Hello help my name is türkişh
Excelde bu formülde takildim yardım edin
Formül bu: 50 ÜZERI NOT SAYISI
bunu hangi formülle bulmam lazım

@rakeshtalwarHi,

I have attached a file with a simple solution to your problem. You can check it and let me know if you have any queries.