Page 1 of 1
[Solved] Current date in validity dropdown list
Posted: Tue May 20, 2025 8:48 am
by 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
Re: Automatic date
Posted: Tue May 20, 2025 2:59 pm
by FJCC
I put the formula
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().
Re: Find current date in validity dropdown list
Posted: Tue May 20, 2025 7:13 pm
by Alex1
Ctrl+; puts the current date in a cell in LibreOffice. This doesn't work in OpenOffice.
Re: Find current date in validity dropdown list
Posted: Wed May 21, 2025 7:43 am
by 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
Re: Find current date in validity dropdown list
Posted: Wed May 21, 2025 12:13 pm
by karolus
donnje wrote: ↑Wed May 21, 2025 7:43 am
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:
you may able to change the format-string to your needs??
Re: Find current date in validity dropdown list
Posted: Wed May 21, 2025 2:23 pm
by donnje
karolus wrote: ↑Wed May 21, 2025 12:13 pm
donnje wrote: ↑Wed May 21, 2025 7:43 am
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:
you may able to change the format-string to your needs??
I read =TEXT(TODAY();"2025-05-21") butI have a error
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 5:10 pm
by Alex1
"yyyy-mm-dd" must be used literally, not substituted. It's a format specification.
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 5:16 pm
by donnje
Alex1 wrote: ↑Wed May 21, 2025 5:10 pm
"yyyy-mm-dd" must be used literally, not substituted. It's a format specification.
idem error
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 5:39 pm
by 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?
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 5:54 pm
by 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
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 6:21 pm
by RoryOF
Are you by any chance editing your code in Writer, which is set to change quotes into curly quotes?
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 6:26 pm
by donnje
RoryOF wrote: ↑Wed May 21, 2025 6:21 pm
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?
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 6:44 pm
by Zizi64
can someone try the formula and upload the file please?
Here is:
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 6:52 pm
by donnje
Zizi64 wrote: ↑Wed May 21, 2025 6:44 pm
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
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 7:15 pm
by 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?
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 7:30 pm
by donnje
Zizi64 wrote: ↑Wed May 21, 2025 7:15 pm
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
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 7:46 pm
by 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.
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 7:58 pm
by donnje
Zizi64 wrote: ↑Wed May 21, 2025 7:46 pm
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
Re: Current date in validity dropdown list
Posted: Wed May 21, 2025 9:30 pm
by Alex1
Fill the validity table with =TODAY()+ROW()-some cell containing a constant.