Try the formulas below:
or enter the beginning fiscal date in another cell, example (Q2).![]()
=INT((R2-DATE(2009,2,1)-WEEKDAY(R2,1))/7)+2
![]()
=INT((R2-Q2-WEEKDAY(R2,1))/7)+2
Try the formulas below:
or enter the beginning fiscal date in another cell, example (Q2).![]()
=INT((R2-DATE(2009,2,1)-WEEKDAY(R2,1))/7)+2
![]()
=INT((R2-Q2-WEEKDAY(R2,1))/7)+2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks