+ Reply to Thread
Results 1 to 3 of 3

Days of savings per quarter using dates

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    asdf
    MS-Off Ver
    Excel 2011
    Posts
    3

    Days of savings per quarter using dates

    I'm trying to get my formula to put the days of savings. Right now it will look up the corresponding quarter and then place the savings in that quarter. My issue is i need it to be a bit more accurate as to the actual dates. An example would be lets say I need to show 180 days of savings and the date I need to start the savings is 10 days before the quarter ends. So i need it to show the 10 days of saving in Q1, 91 days of savings in Q2 then the rest of the days 81 days of savings in Q3. My formula I have now would only put the savings in Q1 and Q2. I believe i need to us Days360() to calculate what i need but i don't know how to put it together
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Days of savings per quarter using dates

    Try this formula in E4,

    =MAX(0,MIN($A4+$B4,E$1)-MAX($A4,EOMONTH(E$1,-3)+1)+1)*$D4

    Then copy down & across
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    10-23-2012
    Location
    asdf
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Days of savings per quarter using dates

    Thanks! It was giving me an extra days worth of savings in total but I was able to just change all the days of savings by -1 day and it works. Can you explain how the EOmonth part of the equation works?

+ 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] Convert time accounting for daylight savings [Australian (non-US) dates]
    By AdamJaffrey in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-15-2016, 11:30 PM
  2. Dates in Excel and Days Remaining in the Quarter
    By kidnos in forum Excel General
    Replies: 4
    Last Post: 04-12-2015, 12:56 PM
  3. Days in this Quarter
    By jibberegg in forum Excel General
    Replies: 4
    Last Post: 04-12-2011, 04:19 PM
  4. Compute number of days per quarter
    By refstone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2008, 03:11 PM
  5. Average Number of Days in a Quarter
    By dvent in forum Excel General
    Replies: 11
    Last Post: 11-16-2007, 05:23 AM

Tags for this Thread

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