Hello, I am looking for some help on rounding dates to the nearest (previous) quarter.
The 4 days where the quarters fall are mar1, june1, sept1, dec1
For example:
I have june3, 2008 and i want june 1,2008
I have nov 30,2010 and i want sept 1,2010
Would be a bonus if you could adjust so that it was a workweek day.
i.e. if june1 2008 is a monday then fine. But if june 1, 2010 is a sunday then i need to to go to next workday so answer would be june 2 for 2010
is this too complicated??
Thx very much in advance
The 4 days where the quarters fall are mar1, june1, sept1, dec1
For example:
I have june3, 2008 and i want june 1,2008
I have nov 30,2010 and i want sept 1,2010
Would be a bonus if you could adjust so that it was a workweek day.
i.e. if june1 2008 is a monday then fine. But if june 1, 2010 is a sunday then i need to to go to next workday so answer would be june 2 for 2010
is this too complicated??
Thx very much in advance