Thank you so much brother ❤

Thanks much

Thank you sir

thanks bro

The year is also increasing with dates

this is exactly what im trying to make happen but when i drag, the date changed. I need it to stay the same and I CANNOT figure it out!

@marcus.H

Жыл бұрын

I wish I could help. What device are you using?

Thanks ❤

Thank you ❤

@marcus.H

5 ай бұрын

You're welcome 😊

The format of the dates in your video changed to day/month/year. How do we try to avoid that error

@marcus.H

Жыл бұрын

I'm unsure

Thank

how can you do this in PC? Windows?

@marcus.H

Жыл бұрын

To autofill dates in Google Sheets on desktop, you can follow these steps: 1. Open a Google Sheet and enter two dates that are a week apart in the consecutive cells. 2. Select and highlight the cells. 3. Click on the bottom right corner of the highlighted cells, and drag it until the cell you want to autofill. You can also use autofill to complete a series of dates by entering text, numbers, or dates in at least two cells next to each other and then highlighting the cells. You’ll see a small blue box in the lower right corner. Drag the blue box any number of cells down or across to create a series of dates⁵. I hope this helps! Let me know if you have any other questions. Source: Conversation with Bing, 04/05/2023 (1) Automatically create a series or list - Computer - Google Help. support.google.com/docs/answer/75509?hl=en&co=GENIE.Platform%3DDesktop. (2) 3 Easy Ways to Add Dates Automatically in Google Sheets. www.guidingtech.com/how-to-add-date-automatically-in-google-sheets/. (3) How to AutoFill Dates in Google Sheets (3 Examples). www.statology.org/google-sheets-autofill-dates/. (4) How to Autofill Dates in Google Sheets - causal.app. www.causal.app/how-to/how-to-autofill-dates-in-google-sheets. (5) Current date with autofill Google Doc from a sheet. stackoverflow.com/questions/67876991/current-date-with-autofill-google-doc-from-a-sheet.

I did what you said, but it filled it with the same date

@marcus.H

3 жыл бұрын

It is necessary to select 2 cells with consecutive dates. If you select only 1 cell to copy, it will autofill that same date

@user-mq3ke4ly1d

3 жыл бұрын

@@marcus.H I got it. Thank you.

Mine just autofills with the same date. What gives?

@marcus.H

5 ай бұрын

These days you need to put 2 or more consecutive dates then use the 2 instead of 1. This also works with dates which are a week apart if you use 3 or more in a row

@marcus.H

5 ай бұрын

If it helps, please help others by leaving a thumbs up 👍

What is “hold “ key?

@marcus.H

10 ай бұрын

This is on mobile. On desktop click and hold the bottom right corner of the square with the date in, then drag down the page

@pg6244

8 ай бұрын

​@@marcus.Hthanks. Was looking for this info.

What app are u using bro ?

@marcus.H

7 ай бұрын

Google Sheets

@Yuri14501

7 ай бұрын

@@marcus.H thanks for the feedback