View Single Post
 
Old 06-08-2021, 01:49 AM
anetteqqq anetteqqq is offline Windows 10 Office 2013
Novice
 
Join Date: Jun 2021
Posts: 3
anetteqqq is on a distinguished road
Default

Quote:
Originally Posted by ProjectPlanner View Post
Replace the semi-colons with a comma, so that the formula for finish is "Week " & CStr(1+datediff("w","1/1/20" & mid(Year([Finish]),3,2);[Finish]))

explanation.

mid(Year([Finish]),3,2) = extracts 2 characters from the year of the finish date starting at the 3rd character. E.g. for "04-Jun-21", year is 2021 and the formula extracts 21.

The 21 from above is then joined to "1/1/20" to form "1/1/2021".


Thank you.
Why only "," on the FINISH formula? Should be on START and DEADLINE too?

The same logic of "mid(Year([Finish]),3,2);[Finish])" is same for START and DEADLINE?

I guess you don't know how to accommodate to make the weeks correct? Year starting with first four day week....etc.

Thanks again
Reply With Quote