Current month

Posted on 2011-04-27
Last Modified: 2012-05-11
Like the way you can use =today() to get the current date, what is the equivalent for getting Current Month and can it be preformatted to appear as MMM-YY

Question by:Seamus2626
    LVL 50

    Accepted Solution

    You can still use =TODAY()

    and custom format cell as mmm-yy

    or use this formula


    regards, barry
    LVL 2

    Expert Comment


    =month(today) -> will give u current month

    and u just change the date format to show the month and year which is available in the cell formattting!!

    or write this to the custom format "mmm-yy"

    hope it helps!!

    Author Closing Comment


    That gave me a Name Error balatheexpert

    Thanks Barry


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now