Libre Calc autofill current date in specific cells

I have a sheet with around 120 pages. Every single one of those page needs to have a date in the form of MMMM-YYYY. (Name of the month - Year) Entering that date 120 times gets tedious, is there a way that it automatically populates that specific cell with the current date in that format by referencing computer’s date? For example, say I opened the sheet in April, so it automatically fills up the designated cell with “April - 2022”, or if I do it in October of next year, it automatically fills up the cells with “October - 2023”.

Thank You.

As a calculatable date value (formatted number):

=TODAY()

and apply number format code MMMM - YYYY to the cell(s) in question.

As a text value:

=TEXT(TODAY();"MMMM - YYYY")
2 Likes

Thank you, you saved me a lot of time.

Suppose the cell used is A1 (in all pages).
Click in the first table A1.
Right-click on the first table name below.
Select “All Tables”.
Write in A1 “=Today()”.
Choose Format>Cells from the menu.
Select Category → Date
In the dialog below at Format-Code enter “MMMM - YYYY”.
Click OK.

In each case without quotation marks.

1 Like