View Single Post
 
Old 06-12-2021, 03:21 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

Your 3 formulas are:

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

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

Deadline Calendar Week = IIf(DatePart("ww",[Deadline],1,2)=53,Year([Deadline])-1 & " Week " & DatePart("ww",[Deadline],1,2),Year([Deadline]) & " Week " & DatePart("ww",[Deadline],1,2))


Note that for tasks without a deadline date, there will be an error.







Reply With Quote