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