Ms Excel Formula Help

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

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.