Return the current quarter between two dates

sdkorin

New Member
Joined
Feb 1, 2018
Messages
17
Hello Excel Gurus!
I'm trying to find a simple formula to give me the currentquarter between two dates. I have to do quarterly performance evaluations on mypersonnel; however, the traditional fiscal year quarters work for works for thepersonnel I have that have been here since 10/1/2018. For the personal I getthroughout the year, they have truncated years. The evaluation period ends on9/30/2019 for everyone, regardless of when they started. But of course, theystill require the same quarterly reviews. Therefore, someone who I’ve had willget a review every 3 months, on the traditional quarters; however, someone elsemight get a review every month if they started in June (4 months before the endof the review period), so that they have all 4 performance reviews.

What I am trying todo is have a formula (similar to:” =ROUNDUP(MONTH(ref)/3,0)”) that will tellme, based on the current date, what quarter the person is, based on the staticend date (9/30/2019) and their start date (which obviously varies.
Thank you all in advance
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,386
4 reviews in 9 months
so no reviews from 1st Oct to 31st Dec
and every one has 4 reviews

so if i had a start date of Jan
I get a review
1 = Jan - Mar
2 = Apr - Jun
3 = Jul - Oct
4 = ?????
 

Forum statistics

Threads
1,081,479
Messages
5,358,939
Members
400,515
Latest member
Finagill

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top