Ask Your Question
0

Continue date with function (calc) [closed]

asked 2017-03-31 09:36:21 +0100

appreciatethehelp gravatar image

Hi all, I am making a document and in sed document there needs to be a column of cells containing all the days of next month (april 2017). Rather than typing all 30 dates out manually, I wonder if there might be a function on libreoffice that will fill in the dates for me…

Any ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-03-31 11:18:35.200978

2 Answers

Sort by » oldest newest most voted
1

answered 2017-03-31 10:50:58 +0100

robleyd gravatar image

Enter a starting date in your first needed cell; grab the little square box at the bottom right of the cell and drag down as far as you need.

edit flag offensive delete link more
0

answered 2017-03-31 09:37:22 +0100

Mike Kaganski gravatar image

=<CellAbove>+1

edit flag offensive delete link more

Comments

After entering that formula I got a message reading:

LibreOffice Calc found an error in the formula entered. Do you want to accept the correction proposed below? =cellabove>+1 So I selected "yes", and the result in the cell read: #NAME? What now?

appreciatethehelp gravatar imageappreciatethehelp ( 2017-03-31 09:53:52 +0100 )edit

<CellAbove> is just a placeholder for something like A1 if you are in A2 ATM.

Mike Kaganski gravatar imageMike Kaganski ( 2017-03-31 10:08:09 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2017-03-31 09:36:21 +0100

Seen: 36 times

Last updated: Mar 31