Help with 2018 spreadsheet

Hi,

Can anybody help me to set the date on the spreadsheet for 2018? I would like to set the date the same as 2017 spreadsheet but I fail.

 

If you click on the first date, then hover over the lower right corner, you should see a +. When you see that +, then click, HOLD, and scroll down until you have 12/31/2018 (I think that would be line 367). Let me know if that works.

 

The problem is that I do not manage to set the desired format : day / month / year . That's why when I scroll down it appears a wrong date. You can take a look to see the error.

 

Delete all but the first date. Then select that field to use as a default.

I see you use a different format. Let me check to see how I can figure that out for you!

 

It works but it still doesn't take the format what I want. From the Format meniu I choose Number , More formats, More date ann tie formats. After I cutomize the date but it doesn't work...

 

You need to highlight the entire column before doing the date formatting.

 

Please send me a PM and I’ll do it for you. There’s a method that can be a pain.

 

I I think I've managed to set the format,but but I can not remove the color from column.
@Marje and Gracie I'll sent my password.

 

So close!! Marje will get it all fixed for you!

 

Thanks, for support.

 

OMG! I copied all dates from the 2017 sheet, and pasted on the 2018 sheet. Then manually changed to 8 from 7.
I will remember this next year.

 

Wow , a lot of work. veru funny!

 

Oh yes, I spent hours doing this on New Year's Eve.

 

You can always ask me for help. It literally takes me 10 seconds to do.

Fixed. Good job doing the formatting.

 

Thanks a lot!

 

You’re welcome!