[Solved] Current date in validity dropdown list

[donnje]

Hello,
I have a column with a drop-down menu connected to another column with all the calendar dates, is there a way to open the drop-down menu and have the current date without having to scroll and search for it?
thanks

Edit: Changed subject, was Automatic date  Make your post understandable by others  -- MrProgrammer, forum moderator

[FJCC]

I put the formula

Code: Select all

=TODAY()

in the cells E4 and E191 on the sheet Foglio2. The list now has today's date as its first and last entry. Its important to set the formatting of those cells to match the date format you want displayed in the list. Otherwise, the drop down list will display the numeric value of the date.
If you want only today's date to be available, change the range of the Validity list to one cell containing the formula =TODAY().

[Alex1]

Ctrl+; puts the current date in a cell in LibreOffice. This doesn't work in OpenOffice.

[donnje]

maybe I explained myself badly, at the moment I already have the drop-down menu with the dates but I would like it to automatically give me the current date, while also leaving the possibility of inserting other dates

[karolus]

maybe I explained myself badly, at the moment I already have the drop-down menu with the dates but I would like it to automatically give me the current date, while also leaving the possibility of inserting other dates

Extend the source-range of the other dates with one cell wich holds the Formula:

Code: Select all

=TEXT(TODAY();"yyyy-mm-dd")

you may able to change the format-string to your needs??

[donnje]

maybe I explained myself badly, at the moment I already have the drop-down menu with the dates but I would like it to automatically give me the current date, while also leaving the possibility of inserting other dates

Extend the source-range of the other dates with one cell wich holds the Formula:

Code: Select all

=TEXT(TODAY();"yyyy-mm-dd")

you may able to change the format-string to your needs??

I read =TEXT(TODAY();"2025-05-21") butI have a error

[Alex1]

"yyyy-mm-dd" must be used literally, not substituted. It's a format specification.

[donnje]

"yyyy-mm-dd" must be used literally, not substituted. It's a format specification.

idem error

[Alex1]

It may depend on your local settings whether yyyy-mm-dd is understood or not.
What does the Format code field show when you press Ctrl+1 and select Date in the Category list?

[donnje]

the format is DD/MM/YYYY
but even if I replace in

=TEXT(TODAY();"dd-mm-yyyy")

it always gives me an error, maybe I'm doing something else wrong

[RoryOF]

Are you by any chance editing your code in Writer, which is set to change quotes into curly quotes?

[donnje]

Are you by any chance editing your code in Writer, which is set to change quotes into curly quotes?

no I dont
can someone try the formula and upload the file please?

[Zizi64]

can someone try the formula and upload the file please?

Here is:

Date_DataValidity.ods

(13.03 KiB) Downloaded 4 times

[donnje]

can someone try the formula and upload the file please?

Here is:

Date_DataValidity.ods

thanks I understand
but I would like that by opening the drop-down menu today's date automatically appears 21, tomorrow the 22nd and so on

[Zizi64]

but I would like that by opening the drop-down menu today's date automatically appears 21, tomorrow the 22nd and so on

Just use the function
=TODAY()
=TODAY()+1
=TODAY()+2
...
in the source cell range of the DataValidity cell.



...Or do you want to use the text
"Yesterday"
"Today"
"Tomorrow"
instead of the date values?

[donnje]

but I would like that by opening the drop-down menu today's date automatically appears 21, tomorrow the 22nd and so on

Just use the function
=TODAY()
=TODAY()+1
=TODAY()+2
...
in the source cell range of the DataValidity cell.



...Or do you want to use the text
"Yesterday"
"Today"
"Tomorrow"
instead of the date values?

great it is works
is there a way for to have a calendar dates faster so you don't have to copy +1 +2 etc every time

[Zizi64]

is there a way for to have a calendar dates faster so you don't have to copy +1 +2 etc every time

Please upload YOUR sample file here to see the desired structure of the data.

[donnje]

is there a way for to have a calendar dates faster so you don't have to copy +1 +2 etc every time

Please upload YOUR sample file here to see the desired structure of the data.

thanks

[Alex1]

Fill the validity table with =TODAY()+ROW()-some cell containing a constant.