Thread: Excel Formula Converting dates to quater ?
View Single Post
Old 15-09-2014, 09:10   #1
Mike
Inactive
 
Join Date: Jan 2004
Age: 63
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel Formula Converting dates to quater ?
Hi all

Hope someone can help on this please

I have a large list of projects with various start and finish dates.

I have to insert a column which shows the yearly quarter works will be delivered. Could be in a single quarter or across quarters.

Any idea on a formula to do this

Example
Start Finish Delivered
1/4/2014 - 30 May 2014 = Q1
1/4/2014 - 15 July 2014 = Q1-Q2
1/05/2014 - 2 Feb 2015 = Q1-Q4

Quarter are

Quarter 1 = 01/04/2014 - 30/06/2014
Quarter 2 = 01/07/2014 - 30/09/2014
Quarter 3 = 01/10/2014 - 31/12/2014
Quarter 4= 01/01/2015 - 31/03/2015

Many thanks for you time and help

Regards

Mike
Mike is offline   Reply With Quote