need help to create a calender

[Nadia1957]

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]

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. 

Thanks

Tauqeer

[#3]

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