View Single Post
  #3   Report Post  
skirkpatrick skirkpatrick is offline
Junior Member
 
Posts: 2
Smile

Works great with the following small mod:

A1: The quarter (so 1, 2, 3 or 4),
A2: The year (eg 2012),
B1: =DATE(A2,(A1-1)*3+1,1)
C1: =DATE(A2,A1*3+1,0)
D1: =C1-B1