Thread: Display week numbers
View Single Post
 
Old 06-13-2021, 03:42 AM
ProjectPlanner's Avatar
ProjectPlanner ProjectPlanner is offline Windows 10 Office 2019
Advanced Beginner
  
Join Date: Mar 2021
Location: UK
Posts: 72
ProjectPlanner is on a distinguished road
Default
Slight errors in formula now corrected:

Start Calendar Week = IIf(DatePart("y",[Start])<4,Year([Start])-1 & " Week " & DatePart("ww",[Start],1,2),Year([Start]) & " Week " & DatePart("ww",[Start],1,2))

Finish Calendar Week = IIf(DatePart("y",[Finish],1,2)<4,Year([Finish])-1 & " Week " & DatePart("ww",[Finish],1,2),Year([Finish]) & " Week " & DatePart("ww",[Finish],1,2))

Deadline Calendar Week = IIf(DatePart("y",[Deadline],1,2)<4,Year([Deadline])-1 & " Week " & DatePart("ww",[Deadline],1,2),Year([Deadline]) & " Week " & DatePart("ww",[Deadline],1,2))
Last edited by ProjectPlanner; 06-14-2021 at 03:12 AM. Reason: Corrected error in formula
Reply With Quote