Day fixed + fetch current month + fetch current year Formula Help

[utking]

Hii Can anyone here help me with an Ms Excel Formula:

My Requirement is to get a fixed day and get current month and current year in excel ??. For ex: I want 21st of every month (FIxed Day) + fetch current month + fetch current year ?? So in this month it will display 21-02-2022 . If I open that in next month it will display 21-03-2022 and so on…

This requrement is for a credit card tracker Due Date calcuation Which update the current month & year every time with a fixed day.

If anyone can help me pls try to share the formula for calcuation.

Thanks.

[Limor_OP]

Hi,
maybe this:
=DATE(YEAR(TODAY()),MONTH(TODAY()),21)

[Clesmond]

This seems to work only for the current month. Previous months seem to change as each day changes. For instance, if I use the formula for March due dates, effective April 1st, the March due date would reflect 04/01/xx. Is there any way to keep monthly due dates throughout the workbook?

[Limor_OP]

Hi,
please upload a sample workbook as instructed in the yellow banner at the top of the page.

[Clesmond]

Now attached.

Clesmond

[utking]

Thankyou so much.

[Limor_OP]

Hi
Of you want last month's results - add -1 to the month section

=DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)