Wednesday, January 13, 2010

Name of last Month

Dear Friends,


When someone prepare some reports and wanna pun headings like “For the month of December, 2009”
“Report for the month of January, 2010”

Than the question comes in mind that "Is there any way so the month will be automatically updated?"

Answer is yes there is a simple way for this first put the formula of today in the cell that is "=Today()" and than do the small work as described under

GO to format cells--->Custom-->"For the month of" mmmm-yy--->Click Ok

and you will get the desired result.


Regards
Hemant

No comments:

Post a Comment

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...