Results 1 to 6 of 6

Showing a decline in Date/Month based on previous cell

Threaded View

avidcat Showing a decline in... 01-25-2014, 09:20 PM
AlKey Re: Showing a decline in... 01-25-2014, 09:25 PM
FDibbins Re: Showing a decline in... 01-25-2014, 09:31 PM
avidcat Re: Showing a decline in... 01-25-2014, 09:40 PM
FDibbins Re: Showing a decline in... 01-25-2014, 09:41 PM
AlKey Re: Showing a decline in... 01-25-2014, 09:47 PM
  1. #1
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Showing a decline in Date/Month based on previous cell

    In Cell A1 I am using the current date function =NOW()
    I am formatting it to show JANUARY-2014 (mmmm-yyyy)

    In Cell A2,A3,A4 etc, I want to show the previous cell minus one month, basically have it show A2 to show, DECEMBER-2013, A3 to show NOVEMBER-2013 etc.

    I found that something simple as =A1-1 would not work

    Thanks for any help.

    Nick
    Last edited by avidcat; 01-25-2014 at 09:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  2. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  3. Display end of month date for previous month
    By erikwvb in forum Excel General
    Replies: 3
    Last Post: 06-20-2011, 01:22 PM
  4. Return to previous month based on cell value
    By herukuncahyono in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-29-2010, 10:00 PM
  5. Replies: 3
    Last Post: 01-09-2010, 08:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1