Happy New Year Everyone!
How can I insert a Month and Year in my heading I want it like this ( Materials to be Retested for the Month of January 2015)
Any help rendered is highly appreciated.
Thank you.
Happy New Year Everyone!
How can I insert a Month and Year in my heading I want it like this ( Materials to be Retested for the Month of January 2015)
Any help rendered is highly appreciated.
Thank you.
Enter this in the cell which you want the header displayed:
Hope this helps!Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
In a spreadsheet or a printout?
In a spreadsheet...
=TEXT(TODAY(),"mmmm yyyy")
will produce "January 2015"
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks