Ms Excel Formula Help
- 894
- 10
-
- Last Comment
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.
- Sort By
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
it’s better someone create excel and provide download link
just use this formula
=DATE[YEAR[TODAY[]],MONTH[TODAY[]],10]
this will give 10th of every month. you can put the day value you need in place of 10. replace all third brackets with normal first bracket – for some reason, the forum does not display properly when first brackets are used.
wahi purana date aur address ka lafda coding/macro banate samay…