+ Reply to Thread
Results 1 to 3 of 3

Sum totals from beginning of last year to the end of last month last year

  1. #1
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Sum totals from beginning of last year to the end of last month last year

    Today is June 11th, 2015. I have a area on my spreadsheet with the title ="YTD Sales to the End of "&$C$57 ,where C57 is dynamic and its always equals last month. So what is displayed is "YTD Sales to the End of May"

    One of my columns is "LYTD Sales" in which I need excel to add up all the sales with a ship date between 1/1/2014 to 5/31/2014.

    Here is the last part of the formula I'm using to add up all the sales with a ship date between 1/1/2015 to 5/31/2015(YTD Sales)
    [Ship Date],"<="&EOMONTH(TODAY(),-1)

    How do I edit this to equal "LYTD Sales to the End of May" and still keep it dynamic.

  2. #2
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Re: Sum totals from beginning of last year to the end of last month last year

    Figured it out.....that was easy

    "<="&EOMONTH(TODAY(),-13)

    Now if I can find out a way to add reputation to myself from myself for getting the answer.

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Sum totals from beginning of last year to the end of last month last year

    You're Welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] YTD total from beginning of year to last month
    By rs1aj in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-05-2015, 06:16 PM
  2. Running Totals from 24 hours to month, month to year without year decreasing
    By Safetyintern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2015, 01:13 PM
  3. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  4. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  5. Excel 2007 : Running Month to Month totals for end of year
    By Josephb1976 in forum Excel General
    Replies: 0
    Last Post: 07-29-2011, 04:54 PM

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