Open kalyan860 opened 2 years ago
Hello. Try increasing it by 86400, instead by 1. That's the number of seconds in a day.
But then I have to rewrite the function everytime I went to add new dates?
Is there a shortcut to copy formula of above cell or to autofill down a column upto the visual selection? Thanks
You can select the cell that hast the formula and yank it with yy
.
Then select the desired range in visual mode and press P
..
The formula should be pasted over the selected range.
I tried doing this using fill function using the numerical value of current date as the initial value and then incrementing it by 1 in the subsequent cells and then converting the resultant numbers to date format. But this is not working.
Is there an easier or better way?