When I drag the date format column in spreadsheet, it'll automatically add 1 day of the next copied column.
I wish to copy the value of the column instead of fill the series. Is there any way to do so?
If I set it to string format, it'll fill the series by adding 1 year to it. The date format that I used was "dd-MMM-yyyy".