Return the current quarter between two dates

sdkorin

New Member
Joined
Feb 1, 2018
Messages
13
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,382
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,077,917
Messages
5,337,163
Members
399,129
Latest member
ericosman

Some videos you may like

This Week's Hot Topics

Top