Google sheets autocomplete dates, or numbers series

This video quickly explains how to create sequential dates, or numbers in Google Spreadsheets, I had a few questions about this, so I thought as always Why not make a short video on, hope it helps someone.

[BiteSizeRandom]

(Yes, I'm a software developer and no one knows I developed AnyCase App, one of the most popular Case Converters out there)

[marianaz]

not working for me . when i select two cells and go downwords, it shows alernative dates e.g if i write 01/12/2023, 01/13/23 in first two cells and select then and go downwords, it creates a repeaded sequence of date i.e 12, 13, 12, 13, 12, 13

[Comfort-Earning-Production]

Thankyou so much bro its working well and helped me a lot. Thanks again and again for saving my dozens of minutes:)

[nRochellew]

This was extremely helpful, and I appreciate that the video just got right to the point without ten minutes of intro! Exactly what I needed to know in 90 seconds. Thanks :)

[grahamcoates]

Thank you, you have saved me a lot of time

[drafaqmahmood]

can anyone help me with the following:
I want to insert dates for a specific month (e.g. July 2022) and skip all the Wednesdays and weekends. Is it possible to have a formula for this rather than typing them out or deleting from the consecutive list?

[kaicairns]

its not working for me like this i've tried everything and it keeps putting the year up in order but nothing else so end up with 01.01.22 02.01.22 then 01.01.23 02.01.24 etc

[kcpauz]

it would have been a great help if you can do excluding some dates.

[lilrafrin]

oh there it was, thanx a lot saved me e headache of typing :)

[theelysium]

Hey,
when I have a table with two variables
x\y 0 | 1 | 2 | 3 | 4
0
1
2
3
4
And I would like to have the functions in the table automatically adapt to said variables; how can I do this? Usually if I would've just one line I could fix one of the variables by writing $A$NUMBER but this is not really a solution in this case.
I am not really sure if my question is understandable tbh ^^ therefore I try to explain it differently:
assuming we have a simple function like "=x+y" in order to get a large map, I would like to list x and y values in a row and column and have the result value within this table. Of course I don't want to write manually:
A2+B1, A2+C1, A2+D1
A3+B1, A3+C1, A3+D1
A4+B1, A4+C1, A4+D1

How can I autocomplete this pattern?

I fiddled around and found a solution. By adding only one $ sign like A$2 or $A2 you can make it only change in one direction (hori, vert).

[ellk]

Thanks for the quick and easy video, thumbs up from me :)

[susannarebera]

It changes the year for me instead of the date of the day. So annoying

[VerDawnHill]

Is there a way to do it nonconsecutive? I want all the dates to be the same when I do that. Ex: 9/6/2024 all the way down

[insanemama]

Is there a way where Column A is dates while column B was numbers... So when I put a Value in Column B, Column A would Auto fill the date when Column B was entered

[TheCutClub]

How do you run consecutive dates for us over in UK who put the day first and not the month? Thank you

[TurKishsoulja]

how do I it for weeks or fortnights instead of days?

[KennyCSalmon]

what if I want to put a space in between them?