Date Auto filling from day 1 to the last day of the month

[Magalela]

Good day.
I have a date table that I want to auto fill from the 1st of the month in cell A2 to last day of the month (C32). The date filling should be linked to cell D2 of the spreadsheet as per the attached.
What excel formula should I use that will make sure that the date filling ends on the last day of the month and does not over lap to the following month?

[Pete_UK]

You can use this formula in A2:

=IF(Pay_Date+ROWS($1:1)-1>EOMONTH(Pay_Date,0),"",Pay_Date+ROWS($1:1)-1)

where Pay_Date is the name you have allocated to cell D2. Copy this down to A32.

Change the date in D2 (e.g. to 1/02/2022) and the final few days will disappear.

Hope this helps.

Pete

[Czeslaw]

Formula 1-28

Please Login or Register  to view this content.

Formula 29-31

Please Login or Register  to view this content.

[Magalela]

You can use this formula in A2:

=IF(Pay_Date+ROWS($1:1)-1>EOMONTH(Pay_Date,0),"",Pay_Date+ROWS($1:1)-1)

where Pay_Date is the name you have allocated to cell D2. Copy this down to A32.

Change the date in D2 (e.g. to 1/02/2022) and the final few days will disappear.

Hope this helps.

Pete

Thanks Pete. Works 100%

[Magalela]

Formula 1-28

Please Login or Register  to view this content.

Formula 29-31

Please Login or Register  to view this content.

Thanks Czeslaw. YOu have solved my problem.

[Pete_UK]

You're welcome, and thanks for the rep.

Pete