Results 1 to 4 of 4

how to get last day of previous 2 months...

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    how to get last day of previous 2 months...

    This formula calculates the last day of the previous month…

    =DATE(YEAR(TODAY()),MONTH(TODAY()),0)

    What would I need to do to adjust so it can give me the last day of the previous 2 months… in this case April. Don’t know if I can take it further but is it possible to just have it give me the 1st day and last day for two months back??? In this case april 1st – april 30th… if that last part can’t be done that’s okay I would like at least to calculate the last day of the previous 2months if possible.

    What I’m doing with the current formula is running a report that picks up accounts that are past due before the last day of the previous month… I want to separate them by months… so that’s why I’m asking for this. Thanks.
    Last edited by jgomez; 06-13-2011 at 01:35 PM.

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