Display week numbers

ProjectPlanner · #6 06-13-2021, 03:42 AM

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))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating 2 percentage fields to show the progress from week to week	Loay harhash	Project	0	04-03-2018 03:26 AM
Need Excel to recognize week numbers based on specific dates	Ktyler	Excel	5	02-06-2017 11:08 AM
Table date format: how display week number?	codeghi	Project	3	07-12-2015 02:40 PM
Display Numbers in CSV file over 15 digits	linan123	Excel	1	06-24-2014 01:54 PM
Display Random Numbers as Transition	greenbutton	PowerPoint	0	03-09-2011 04:43 PM