Should be a quick fix (Hopefully).
On the attached file I want to select a month from a validation, e.g. February and have 2 cells update with the first and last date of the month, 01/02/2011 & 28/02/2011. Possible?
Thank you
Should be a quick fix (Hopefully).
On the attached file I want to select a month from a validation, e.g. February and have 2 cells update with the first and last date of the month, 01/02/2011 & 28/02/2011. Possible?
Thank you
Last edited by guerillaexcel; 03-25-2011 at 11:07 AM.
Try:
=EDATE(C2&1,0)
and
=EDATE(C2&1,1)-1
If you are in XL2003 or earlier, the EDATE function is an analysis toolpak addin function, to install go to Tools|Addin, select Analysis Toolpak.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That is perfect, cheers NBVC!!
Thanks for the very fast reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks