Convert Date to first of month, i.e. 12Jul24 to 1Jul24

[slam]

I have a series of dates in the format d-mmm-yy h:mm:ss

For example:

17-Nov-23 0:00:00
29-Jun-23 0:00:00
2-Oct-23 0:00:00
29-Feb-24 0:00:00
30-Jun-23 0:00:00
1-Jul-24 0:00:00
11-Dec-23 0:00:00

In an adjacent column, I need to convert these to be the 1st of the same month/year. I.e., the dates above would become:

1-Nov-23 0:00:00
1-Jun-23 0:00:00
1-Oct-23 0:00:00
1-Feb-24 0:00:00
1-Jun-23 0:00:00
1-Jul-24 0:00:00
1-Dec-23 0:00:00

Is there a formula that could do this for me?

Thanks!

 

[hagia_sofia]

How about:

=EOMONTH(A1,-1)+1

 

[slam]

Ah, I did not know there was a function for this, thank you!

So the -1 is for previous month, then the +1 is to add 1 day, making it the 1st of the month I'm looking for?

 

[hagia_sofia]

Ah, I did not know there was a function for this, thank you!

So the -1 is for previous month, then the +1 is to add 1 day, making it the 1st of the month I'm looking for?

Yes, last day of the previous month plus one day