i want to keep the day constant but increase the month by 1 in every cell how
ex 27/01/2014, 27/02/2014, 27/03/2014 etc
First time here? Check out the FAQ!
ex 27/01/2014, 27/02/2014, 27/03/2014 etc
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.
Asked: 2020-03-18 16:05:49 +0100
Seen: 62 times
Last updated: Mar 18 '20
Auto Formatting Sheet based on date [closed]
What is the equivalent of the DATEINFO function in Lotus 123? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]