How to get list of months for specific number of years?
How do I get continued list of months for specific number of year?
e.g. if I entered 5 years, starts from January 2014 then below list will come which have January 2014 to December 2014 then again January 2015 to December 2015...till December 2019.
How can I get this any one have idea?
Last edited by milindbharambe; 04-24-2014 at 01:50 AM.
like this?
Years.xlsx
Click on the star if you think I helped you
Hi,
You can only automate that with a macro. But why not just enter 1/1/2014 in A1 and in A2
Formula:
Please Login or Register to view this content.
Then copy A2 down to A60
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks adyteo...This is what I wanted exactly.
thanks adyteo...This is what I wanted exactly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks