Hello All,
I have been working in a sheet and there is only on thing needs to be done, and is what I need your help.
I created a simple calendar, Monday until Sunday and on the left side there are the normal weekdays, and I am getting a problem
because on the right side I am suppose to create this the same calendar week but using the fiscal year that for me start in 1st of October.
It is not that easy, because I have a box that I can enter the information (Month and year), meaning that the months always will change the position
e.g.
Untitled.jpg
On the top there is the box and below the calendar. If you notice, on January 1st begins at week 52 and not at week 1. So, I want to do the same for October 1st.
I don't know if is a bit confused but if you need more information I can posted more.
The formula I used to calculate week 52 is below:
=IF(H8="";TRUNC((I8-WEEKDAY(I8;2)-DATE(YEAR(I8+4-WEEKDAY(I8;2));1;-10))/7);TRUNC((H8-WEEKDAY(H8;2)-DATE(YEAR(H8+4-WEEKDAY(H8;2));1;-10))/7))
I hope this information could help.
Thanks in Advantage.
Bookmarks