We help IT Professionals succeed at work.

Current month

Seamus2626
Seamus2626 asked
on
260 Views
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

Thanks
Seamus
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
yes,

=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

Commented:
=MONTH(today)

That gave me a Name Error balatheexpert

Thanks Barry

Seamus
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.