hi Everyone,
The issue is Sep 6 2019 needs to display as Week 2 of Sep, but I am getting Sep Week 1. Week no will change
on every Saturday. my Financial calendar is 4-4-5 basis. our 2019 financial year is starting on 29 Dec 2018 to
Dec 27 2019, so based on this period, 29 dec 2019 to 4 jan 2019 is the Week 1 of Jan 2019, from 5 th Jan 2019
week 2 will start. like this I need to show Sep 6 as week 2.
my current project year starts on Sep 6. have 104 weeks in excel sheet to enter weekly hours. these weeks
will generate based on the start date(Sep 6 2019). 7 days will add to the previous week, like this 104 weeks
will
create.
Below code is returning Sept week 1 as per ISO week nos. But i need to display as Sept week 2weekNo= Trim(Format(dateCell.Value, "\ mmm " & "\W" & DatePart("ww", dateCell) - DatePart("ww",
DateSerial(Year(dateCell), Month(dateCell), 1)) +1))
It will be grate help if I get any Excel formula/VBA code to get the week no. I have searched lot of forums
for this.
The issue is Sep 6 2019 needs to display as Week 2 of Sep, but I am getting Sep Week 1. Week no will change
on every Saturday. my Financial calendar is 4-4-5 basis. our 2019 financial year is starting on 29 Dec 2018 to
Dec 27 2019, so based on this period, 29 dec 2019 to 4 jan 2019 is the Week 1 of Jan 2019, from 5 th Jan 2019
week 2 will start. like this I need to show Sep 6 as week 2.
my current project year starts on Sep 6. have 104 weeks in excel sheet to enter weekly hours. these weeks
will generate based on the start date(Sep 6 2019). 7 days will add to the previous week, like this 104 weeks
will
create.
Below code is returning Sept week 1 as per ISO week nos. But i need to display as Sept week 2weekNo= Trim(Format(dateCell.Value, "\ mmm " & "\W" & DatePart("ww", dateCell) - DatePart("ww",
DateSerial(Year(dateCell), Month(dateCell), 1)) +1))
It will be grate help if I get any Excel formula/VBA code to get the week no. I have searched lot of forums
for this.