|
|
#2
06-04-2021, 11:42 AM
|
||||
|
||||
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". Last edited by ProjectPlanner; 06-04-2021 at 11:43 AM. Reason: spelling error 
|
|
|
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 |
Windows 10 
Office 2019
Threaded Mode