Ask Your Question

i want to keep the day constant but increase the month by 1 in every cell how

asked 2020-03-18 16:05:49 +0100

RAN38731 gravatar image

updated 2020-03-18 17:02:12 +0100

erAck gravatar image

ex 27/01/2014, 27/02/2014, 27/03/2014 etc

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-03-18 17:01:00 +0100

erAck gravatar image

Enter two dates into two cells, like 27/01/2014 and 27/02/2014, then select both cells and pull them down at the bottom right handle.

Or enter just one date 27/01/2014 and select a cell range including that cell at the top and invoke menu Sheet -> Fill Cells... -> Fill Series..., Series Type Date, Time Unit Month, Increment 1.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-03-18 16:05:49 +0100

Seen: 57 times

Last updated: Mar 18