Date won't populate correctly

[RodneyC]

Another question about a spreadsheet I've inherited.

C793 has a value of 2021-10-01. If I drag it down, it changes to 2021-10-02, 2021-10-03 and so on. I actually need all the cells below to have a value of 2021-11-01. If a change the value to 2021-11-01 it displays as 11/1/2021. This doesn't work for me as Column I reads from this and displays a #VALUE error.

I've looked at the cell formatting of C793 and it is "General". If I change the cell formatting in C794 to General it changes the value to 44501 which obviously doesn't work for me either. I've changed the formatting to Custom and entered yyyy-mm-dd and while that display correctly, in column I794 it still displays as #VALUE. The formula in I794 is =DATEVALUE(C794). I could change this to =C794 but I'm concerned that doing so may affect other cells in other workbooks.

How can I change C794 and all other cells below it so they will display 2021-11-01 as needed?

Thanks in advance

 

[arthurbr]

Format your cell as text before entering the date
If it is the result of some calculation enter =your_calculation&"" to make it text

 

[RodneyC]

Format your cell as text before entering the date
If it is the result of some calculation enter =your_calculation&"" to make it text

Formatting as text solved it. THANK YOU

 

[arthurbr]

Most welcome