?
Solved

excel - last month function?

Posted on 2003-02-19
3
Medium Priority
?
1,656 Views
Last Modified: 2012-05-04
the =today() function when formatted as "mmmm" shows 'February' but how would you do te same thing so it would show the previous month? 'January' for example.  But just so if it was 02/02/2003 it would just change the month not the day or year..?

please help, thanks!
0
Comment
Question by:xeroxed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Expert Comment

by:bullethead
ID: 7980656
=MONTH(TODAY())-1

shoulud do it
0
 
LVL 43

Accepted Solution

by:
Steve Knight earned 108 total points
ID: 7980667
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),"mmmm")

should do it to get it as text

or

DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)

as a date which you can format as mmmm

hth

Steve
0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 7980669
(crossposted again!!)
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

777 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