Hi,
attached file -
In the Sheet1 issue I wrote the date in the blue cell
And in the yellow cell I converted it to the desired structure
The problem is that it did not pull out well this month -
Instead of 18/4/2022 it was written 18/1/2022
Why?
Hi Lea,
I don't recommend converting dates to text because it renders them useless in formulas. Why don't you use a custom number format:
yyyy-mm-dd
If you insist on having the date in a text format, then use this formula:
=TEXT(B8,"yyyy-mm-dd")
Mynda
Hi,
In the attachment here
I did what you suggested in the blue cell
But then the Match fails to pull out the figure - why?
Thank You!
Leah
I used the formula you suggested above -
TEXT (B8, "yyyy-mm-dd") =
And it worked for me, thank you very much !!
Personally, I'd use an Index/Match. I have what I believe you are looking for attached.
