Hi all
I found really great formula from Daddylonglegs in below thread
http://www.excelforum.com/excel-gene...html?p=2898398
this is what i was looking for. but it has some limitation for me. i need your wise brain here.
this formula works great if all quarters are in same year and week starts from Sunday.
but if the quarter runs thru years, it's not working and also i cannot figure out how i can shift starting day from sunday to other day
for example,
Q1 in my company starts from Nov.
Q1 : 2011-11 ~ 2012-01
Q2 : 2012-02 ~ 2012-04
Q3 : 2012-05 ~ 2012-07
Q4 : 2012-08 ~ 2012-10
formula works perfectly for Q2,Q3,Q4. but not for Q1. and i can't figure out how i can set start day of week
the formula i used is from the thread above.
=INT((A5-WEEKDAY(A5)-LOOKUP(A5,DATE(YEAR(A5),{2,5,8,11},1)))/7)+2
many thanks in advance
Bookmarks