need help to create a calender

%3CLINGO-SUB%20id%3D%22lingo-sub-2245222%22%20slang%3D%22en-US%22%3Eneed%20help%20to%20create%20a%20calender%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2245222%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20wanted%20to%20create%20a%20schedule%20I%20dragged%20the%20small%20cross%20at%20the%20corner%20to%20the%20right%20it%20created%20dates%20but%20it%20stopped%20until%20the%2015%2F03%2F2021%20then%20started%20to%20count%20in%20years%2015%2F03%2F2022.%20I%20wanted%20to%20continue%20in%20weekdays.%20Any%20clue%20what%20should%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2245222%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2252349%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20to%20create%20a%20calender%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252349%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1012939%22%20target%3D%22_blank%22%3E%40Nadia1957%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20possibility%20may%20be%20that%20some%20rows%20are%20hidden%20in%20between.%20Check%20the%20row%20number%20where%20date%20is%26nbsp%3B%3CSPAN%3E5%2F03%2F2021%20and%20also%20check%20the%20row%20number%20where%20you%20are%20getting%26nbsp%3B5%2F03%2F2022.%20If%20the%20difference%20in%20two%20rows%20is%20more%20than%20one%20like%20belwo%20image%20it's%20mean%20some%20rows%20are%20hidden.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tauqeeracma_0-1617468071147.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F269327iCC3CB41C53AA9866%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tauqeeracma_0-1617468071147.png%22%20alt%3D%22tauqeeracma_0-1617468071147.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2252374%22%20slang%3D%22en-US%22%3ERe%3A%20need%20help%20to%20create%20a%20calender%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1012939%22%20target%3D%22_blank%22%3E%40Nadia1957%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMany%20possibilities%20!!!%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EInfo%20-%20Rules%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20I%20can%20recommend%20you%20add%20the%20file%20(without%20sensitive%20data)%20with%20the%20problem.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIn%20this%20way%20you%20can%20get%20a%20concrete%20proposal%20for%20a%20solution.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESo%20everyone%20can%20be%20helped.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When I wanted to create a schedule I dragged the small cross at the corner to the right it created dates but it stopped until the 15/03/2021 then started to count in years 15/03/2022. I wanted to continue in weekdays. Any clue what should I do?

2 Replies

Hi @Nadia1957 

 

One possibility may be that some rows are hidden in between. Check the row number where date is 5/03/2021 and also check the row number where you are getting 5/03/2022. If the difference in two rows is more than one like belwo image it's mean some rows are hidden. 

tauqeeracma_0-1617468071147.png

 

Thanks

Tauqeer

 

@Nadia1957 

Many possibilities !!!

Info - Rules:

https://techcommunity.microsoft.com/t5/excel/welcome-to-your-excel-discussion-space/m-p/2204395

If I can recommend you add the file (without sensitive data) with the problem.

In this way you can get a concrete proposal for a solution.

So everyone can be helped.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)