Quote:
Originally Posted by Excel Dumbo
Hi Spencer,
Thanks a lot for your reply. I did try both the formula and it is giving me a #NAME? error. I am using excel 2003 and do not have analysis tool pack
To give u a bigger picture of the problem
I have two data validation lists one for 2011 (Jan-11, Feb-11, Mar-12, Apr-11)
and second data validation list 2012 (Jan-12, Feb-12, Mar-12, Apr-12)
I do not intend to use both data validation lists . I prefer to use only one data validation list, that is, 2011 . Corresponding month for 2012 should automatically come up when i select the month feom 2011 data validation drop down.
Hope this will further define the problem.
Thanks Spencer. Awaiting ur reply.
|
Without the analysis toolpak you can use this version of the formula:
=DATE(YEAR(A1)+1,MONTH(A1)+1,DAY(A1)-1)
But as you can see from =EOMONTH(A1,12) things are far easier with it, so if you can install it I would highly recommend it.