Thread
:
calculating per quarter
View Single Post
#
3
skirkpatrick
Junior Member
Posts: 2
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
Reply With Quote
skirkpatrick
View Public Profile
Send a private message to skirkpatrick
Find all posts by skirkpatrick