Quarter end formula based on todays date

Posted on 2014-08-29
Last Modified: 2014-08-29
Experts, I need a formula to calculate the end of the quarter based on today.  Can you please let me know what this might be?  

thank you
Question by:pdvsa
    LVL 31

    Expert Comment

    by:Rob Henson
    You can set up a simple table with quarter end dates and then use a vlookup formula to find your result:

    Table (A1 to A4)

    Date in D3, formula:


    I have deliberately left the last parameter of the lookup blank so it finds a close match without going beyond the date being looked up.

    Rob H
    LVL 24

    Expert Comment

    Are you looking for the formula at the following web page?:

    < >

    Or, are you looking for the formula given here?:

    < >

    Sorry, if both are not what you are looking for.
    LVL 47

    Accepted Solution


    pls try



    Author Closing Comment

    Thank you.  To the others:  thank you but not looking for a lookup.  Also might want to copy the formula from teh website i/o linking to it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now