Results 1 to 6 of 6

formula to calculate "previous month"

Threaded View

Gti182 formula to calculate... 11-15-2010, 05:04 AM
DonkeyOte Re: formula to calculate... 11-15-2010, 05:09 AM
Gti182 Re: formula to calculate... 11-15-2010, 05:21 AM
Gti182 Re: formula to calculate... 11-15-2010, 05:25 AM
DonkeyOte Re: formula to calculate... 11-15-2010, 05:32 AM
Gti182 Re: formula to calculate... 11-15-2010, 05:49 AM
  1. #1
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    469

    formula to calculate "previous month"

    I have an input cell in which i enter the current month and would like a formula to calculate the previous month based on my current month input cell.

    I've tried the "=current month input cell - 1" but this doesn't work :P

    The TODAY & NOW functions are no good here i would think as the current date differs from the actual date often by a couple of months.
    Last edited by Gti182; 11-15-2010 at 05:21 AM.

Thread Information

Users Browsing this Thread

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

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