week numbers
1 Topic
Week Numbers between a Start and End Date
Hi All I dont know if anyone can help!! a concept that sounds simple in my head is just not coming into fruition when im trying to do it in Excel. I am trying to find a formula that will calculate the week number of a certain date that will fall between a start and date. So for example if my start date is 25/04/2018 and an end date of 20/07/2018 this will be 13 weeks (Monday to Friday) , but if i want to know what week number the 13th June would fall on is there formula that can do this? So far i have managed to use a formula where i physically just need to look where the start date falls between a Week start and week end by using the roll back to the previous Monday from the start date but the snag is when I enter a date that falls on a Monday i do not want it to roll back to the previous monday as this Monday would count as week one ?? if i am going about this all wrong or if there's an easier way i would be grateful for some adviceSolved9.3KViews0likes6Comments