Convert all dates of a month to that month's last date

[imran1059]

Hi All,

I have thousands of lines of dates in a column with different dates, different month and different year. All I need is to have all the dates of a month to be converted into their last date only.

Date available	Date Required
28-Nov-2018	30-Nov-2018
26-Feb-2019	28-Feb-2019
27-Feb-2019	28-Feb-2019
05-Aug-2019	31-Aug-2019
27-Sep-2019	30-Sep-2019
09-Nov-2019	30-Nov-2019
12-Nov-2019	30-Nov-2019

Regards,
Imran.

 

[joeu2004]

If "date available" is in A2 and "date required" is in B2, enter the following into B2 and copy down the column:

=EOMONTH(A2, 0)

Format as Custom dd-mmm-yyyy .