+ Reply to Thread
Results 1 to 4 of 4

How do I compute end date of each quarter according to the year

  1. #1
    Registered User
    Join Date
    03-10-2020
    Location
    Hong kong
    MS-Off Ver
    MAC 2008
    Posts
    25

    Lightbulb How do I compute end date of each quarter according to the year

    Lets say I have the "years" present, is it possible to deduce the end date of each quarter according to the year with excel formulas?

    Table:

    Years Q1 Q2 Q3 Q4
    2020
    2019
    2018
    2017
    2016
    2015
    2014


    Thanks!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: How do I compute end date of each quarter according to the year

    B2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy right and down (provided your table headers are located in row1 and column A)
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    03-10-2020
    Location
    Hong kong
    MS-Off Ver
    MAC 2008
    Posts
    25

    Re: How do I compute end date of each quarter according to the year

    thanks g, got your private message too

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: How do I compute end date of each quarter according to the year

    Perfect! Here the attachment could be probably an overkill, but anyway i copied part of your post to a file, made text-to-columns and then wrote the formula (checking if it works as expected.
    Note it uses day 0 of months 3*1+1=April, 3*2+1 = July etc. to get last day of previous month. Its shorter (and quicker) than relying on =EOMONTH( some date ,0)

+ 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] Show date as Financial year quarter
    By Aggaire in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-27-2019, 05:14 AM
  2. Date + #of days to Correct Quarter and Year
    By courthamr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2016, 06:53 AM
  3. [SOLVED] Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date
    By cartica in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2014, 04:22 PM
  4. Fiscal Quarter/Year into a date format
    By bluerog in forum Excel General
    Replies: 2
    Last Post: 12-14-2009, 02:36 PM
  5. Date Format - Quarter and Fiscal Year
    By bluerog in forum Excel General
    Replies: 1
    Last Post: 11-04-2009, 12:04 PM
  6. [SOLVED] Change date to quarter of a year
    By rita in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2005, 08:06 AM
  7. Replies: 7
    Last Post: 05-11-2005, 04:06 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