Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft-excel-courses - displaying current month

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Displaying the current month

microsoft-excel-courses - Displaying the current month

ResolvedVersion Standard

Displaying the current month

Hello,

I'm wondering how I can get the value of the current month into a cell. I have used the TODAY function to get the current date, how do I extract the month from this?

Thanks,

Zohra

RE: Displaying the current month

Hi Zohra,

Thank you for the question

If you use the today function you can then format the cells to return the month. To do this go into Format>Cells and go down to the option that says Custom. In the "Type" field enter mmmm and you will return the current month.

Hope that helps, anything else let me know

Tracy

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.