How to transform standard format into a short date format (french excel) with a condition?

Good morning to the community

I would like to insert a new column at the right of the column H? I would like to apply a short date format (for example 01/04/2024) by taking data from the column H. I want to apply the first day of the month every time as condition.

date.png

Can you do this?

Thank you a lot.

Could you show us what your expected outcome looks like?
I can only see one row with anything that looks similar to a date. Do you want the date just for that one row, or all rows above it, or something else?

A larger sample dataset, with expected outcome, could be useful to provide you with a solution.

BSB

This will work on the sample provided and give the expected results.
It may not work perfectly on real data depending on the content in column H. With such a small sample it's impossible to know.

Please Login or Register  to view this content.

BSB

And that is EXACTLY why I said a larger sample dataset would be useful for us to provide you with a solution.
What's the point in showing just one scenario when you need several scenarios to be taken into account?

And now you've told us about the different scenarios but not provided us with an example of your expected outcomes.

I'm going to back away from this now as there are plenty of other people that need help that are prepared to explain what they need.
I hope you find a solution.

BSB

Thank you for your feedback BadlySpelledBuoy. I can't share a larger sample dataset with several scenarios for personal reason.

I close this thread because it's solved the main part of the problem.