# Ms Excel Formula Help

74°
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 21th of every month ?? 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 month & year every time with a fixed day.

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

Thanks.

9 Dimers
• Sort By

wahi purana date aur address ka lafda coding/macro banate samay…

I am sure there would be a shorter way, but from my limited knowledge this would do the job ( if i understood the requirement correctly)

Use formula “=YEAR[TODAY()]” in cell A1

Use formula “=MONTH[TODAY()]” in cell A2

Use formula “=DATE[A1,A2,21]” in cell A3

Note- Kindly replace angular brackets with circular brackets, not able  to post them here

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

Sorry not much familiar with excel but tried to understand what you mentioned. Would this suffice ?

DAYS360 and +30 would work.
Just guessing

Thanks all for your valuable inputs. Got the job done..

cheers

Cell A1 =YEAR{TODAY()}

Cell B1 =MONTH{TODAY()}

Cell C1 =DATE{A1,B1,DAY[TODAY()]}

Note : left hand side just for information and right hand side is the code use small bracket only

ALT + H + FI + S
Here you can define your series, it can be in days , month wise and also give the step value, will calculate for all the periods accordingly