#1
|
|||
|
|||
Table date format: how display week number?
Ciao
I would like to create a table for my Gantt, that displays the week number unit instead of the date. My goal is to create a table that instead of showing the start and finish date for a task, displays the start week: i.e. Week 1, Week 2, ...ect. and the finish week. I have found in Internet this answer: create a customized text field with the formula "Week " & CStr(1+datediff("w";[Project Start];[Start])) For the finish date, in another Text field, replace [Start] by [Finish] I have two questions:
Regards |
#2
|
|||
|
|||
You can change the date display in a table to Weekly format - no need for a custom formula. My suggestion is to create a new table (copy and existing and rename) then change the date format to the "W4/4"
That date format I believe is ISO compliant. |
#3
|
|||
|
|||
Thank you very much Julie: it works great!
How are you? Were you in holiday? Regards |
#4
|
|||
|
|||
You're welcome and thanks for the feedback. Sorry about the delay - not on holiday just distracted by other things.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto populating dates on timesheet for week from one inputted date | ohi | Word VBA | 3 | 12-04-2014 12:11 PM |
How to format cell in order to display *both* time and date | SamyCode | Excel | 3 | 01-22-2013 03:30 PM |
Milestones: Display of - turning off the display of the date | Pmacdaddy | Project | 3 | 01-18-2013 05:42 PM |
Displaying Work Week instead of date in a column. | whitney07 | Project | 1 | 07-05-2012 02:27 PM |
Formula to auto calculate Day of the week based on Date | prasad@dmci.ca | Excel | 1 | 11-29-2011 01:05 PM |