How do I put the last day of the month on its corresponding month of the year in MS excel?

How do I put the last day of the month on its corresponding month of the
year in MS excel?

How do I put the last day of the month on its corresponding month of the
year in Excel? Because I need to do this from 2005 to 2025 in creating a
Time Dimension Table. I tried to find a solution in Visual Studio but I
didn't find any option to customize it.
COLUMN C COLUMN D
Friday, July 01, 2005 2005-07-31 Saturday, July 02, 2005 2005-07-31
Sunday, July 03, 2005 2005-07-31 Monday, July 04, 2005 2005-07-31 Tuesday,
July 05, 2005 2005-07-31 ....... .... ... Wednesday, July 27, 2005
2005-07-31 Thursday, July 28, 2005 2005-07-31 Friday, July 29, 2005
2005-07-31 Saturday, July 30, 2005 2005-07-31 Sunday, July 31, 2005
2005-07-31 ..... ... .. Monday, August 01, 2005 2005-08-31 Tuesday, August
02, 2005 2005-08-31 Wednesday, August 03, 2005 2005-08-31 Thursday, August
04, 2005 2005-08-31 Friday, August 05, 2005 2005-08-31
and so forth all the way to year 2025
Thank you in advance!
Beau