Hi!
I have dates in a column:
23.1.2023
25.1.2023
8.2.2023
22.2.2023
15.3.2023
3.2.2023
This is the current date: 4.2.2023
I have tried to create a formula to pick me the date 8.2.2023, which is the nearest date in the future.
Just can't figure it out!
Any help?
Use thisas a conditional formatting ruleFormula:
Please Login or Register to view this content.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Firstly correct date format, your date not in date format it must be 23/01/2023 so on...
suppose your data in a2 to a7
Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thank You! I'm in Finland so I had to translate this into:
=MIN(JOS($A$1:$A$6-TÄMÄ.PÄIVÄ()>0;$A$1:$A$6))
..it works!
Thanks! I'm in Finland and we usually announce the date in this format: dd.mm.yyyy
I got the code to work by translating it into:
=JOS(TÄMÄ.PÄIVÄ()>MAKS($A$2:$A$7);"";MIN($A$2:$A$7;1+LASKE.JOS($A$2:$A$7;"<"&TÄMÄ.PÄIVÄ())))
...and this gives me the sequence number of the right date!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks