Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2015, 07:25 AM
codeghi codeghi is offline Table date format: how display week number? Windows 7 64bit Table date format: how display week number? Office 2010 64bit
Advanced Beginner
Table date format: how display week number?
 
Join Date: Jan 2010
Posts: 38
codeghi is on a distinguished road
Default 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:
  1. Instead of "Project Start", can I use a fix date like 01-01-2015?
  2. If I have a task that starts in 2015 and finishes in 2016, the formula shows a week number more than 52: how can I modify the formula in such way that it will be showed a week number 1 at the beginning of the year instead of 53?


Regards
Reply With Quote
  #2  
Old 07-01-2015, 05:47 PM
JulieS JulieS is offline Table date format: how display week number? Windows 7 64bit Table date format: how display week number? Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Attached Images
File Type: jpg ww.jpg (112.6 KB, 26 views)
Reply With Quote
  #3  
Old 07-12-2015, 04:42 AM
codeghi codeghi is offline Table date format: how display week number? Windows 7 64bit Table date format: how display week number? Office 2010 64bit
Advanced Beginner
Table date format: how display week number?
 
Join Date: Jan 2010
Posts: 38
codeghi is on a distinguished road
Default

Thank you very much Julie: it works great!
How are you? Were you in holiday?
Regards
Reply With Quote
  #4  
Old 07-12-2015, 02:40 PM
JulieS JulieS is offline Table date format: how display week number? Windows 7 64bit Table date format: how display week number? Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome and thanks for the feedback. Sorry about the delay - not on holiday just distracted by other things.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table date format: how display week number? 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
Table date format: how display week number? Formula to auto calculate Day of the week based on Date prasad@dmci.ca Excel 1 11-29-2011 01:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft