Dear Arno,
I have received your reply. it is good if you count the # of quarters. But
let's discuss this way.

if an employee's stard date is 15 February (B2) the result should return 4
Quarter, but he formula you have adviced me is howing something like this.

1 sep 05 (B2) = 3 quarter, which I want the contrary for example

if it is between Oct and Dec it should return me 1
if it is between Jul - Sep it should return me 2
if it is between Apr - Jun it should return me 3
if it is between Jan - Mar it should return me 4

sorry for wrong info I wrote in my first message.
if you are online, let's discuss this online by skype (daoudfakhry1985)

Thanks
Daoud

"arno" wrote:

Hi,

let's assume you have a date in B2, then the following formula will
give you the quarter based on the month of that date:

=INT((MONTH(B2)-1)/3)+1

arno