Results 1 to 7 of 7

Formula to display the last day of the previous month

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Formula to display the last day of the previous month

    I am using the following formula to show the first day of previous 6 month cycle.

    =DATE(YEAR(TODAY()),MONTH(TODAY())-6,1)

    That formula would display: 07/01/2009

    I want to have another formula show the last day of the previous month.

    Basically it would display: 12/31/2009

    I appreciate any help with this.

    thanks,
    Nick
    Last edited by avidcat; 01-22-2010 at 10:02 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