Advertisement
- Home
- Software
- Office / Productivity
- Project Management
- Microsoft Project
- Change Dates to numbers in Project
Advertisement
- 1. jbfraser 43,025
- 2. bobsegrest 39,375
- 3. dbase118 16,875
- 4. lyonst 15,864
- 5. winzig 6,625
- 6. harisrashid 5,500
- 7. weellio 5,000
- 7. Thomas_V... 5,000
- 9. tedbilly 4,875
- 10. KCTS 4,500
- 11. suprhkr 4,000
- 12. LSMConsu... 3,500
- 13. brent_ca... 3,000
- 13. jdera 3,000
- 15. whoajack 2,750
- 1. bobsegrest 178,302
- 2. harisrashid 157,054
- 3. winzig 136,613
- 4. dbase118 112,398
- 5. Bembi 64,367
- 6. jbfraser 55,425
- 7. MSProjec... 42,118
- 8. RobertoE... 29,888
- 9. lyonst 28,866
- 10. leslynf 28,153
- 11. Miles_st... 25,662
- 12. gova 18,075
- 13. sinjin 14,552
- 14. aflockhart 12,582
- 15. bruintje 9,175
| 05.07.2008 at 08:12AM PDT, ID: 23383025 | Points: 500 |
|
[x]
Attachment Details
|
||
Change Dates to numbers in Project
Tags:
Microsoft, Project, 2007
What I was wondering is can I in project change the dates so they instead reflect the number of days worked (i.e. project starts at 1/1/08: Ok so instead of an early start display of "1/5/08" it would display "4" because those are the number of days that have passed.)
Also it would be great if the number did not include weekends. just days worked. I set up a custom set so it does Early Start, Early Finish, Late Start, Late Finish
Start your free trial to view this solution
Also it would be great if the number did not include weekends. just days worked. I set up a custom set so it does Early Start, Early Finish, Late Start, Late Finish
Question Stats
Zone:
Software
Question Asked By:
jonmclean2
Question Asked On:
05.07.2008
Participating Experts:
1
Points:
500
Views:
0
Translate:
Loading Advertisement...
Loading Advertisement...
| Microsoft |
- Internet Protocols
- Applications
- Development
- OS
- Hardware
- Windows Security
| Apple |
- Operating Systems
- Hardware
- Programming
- Networking
- Software
| Internet |
- Search Engines
- File Sharing
- WebTrends / Stats
- Spy / Ad Blockers
- Web Browsers
- New Net Users
- Web Development
- Chat / IM
- Anti Spam
- Web Servers
- Anti-Virus
- Email Clients
| Gamers |
- Tips
- Online / MMORPG
- Puzzle
- Emulators
- Action / Adventure
- Role Playing
- Consoles
- Game Programming
- Strategy
- Sports
- Misc
- Computer Games
| Digital Living |
- Hardware
- New Net Users
- New Users
- Software
- Digital Music
- Gaming World
- Home Security
- Apple
- Networking Hardware
| Virus & Spyware |
- Vulnerabilities
- IDS
- Encryption
- Anti-Virus
- Operating Systems Security
- Software Firewalls
- WebApplications
- Cell Phones
- Operating Systems
- Internet
- Hardware Firewalls
| Hardware |
- Handhelds / PDAs
- Displays / Monitors
- Components
- Networking Hardware
- Peripherals
- Laptops/Notebooks
- Storage
- Servers
- Desktops
- New Users
- Misc
- Apple
| Software |
- System Utilities
- Industry Specific
- Network Management
- Photos / Graphics
- Page Layout
- VMWare
- Misc
- Web Development
- OS
- CYGWIN
- Voice Recognition
- Message Queue
- Quality Assurance
- Security
- Firewalls
- MultiMedia Applications
- Development
- Database
- Office / Productivity
- Business Management
- OS/2 Apps
- Server Software
- Internet / Email
| ITPro |
- OS
- Storage
- Encryption
- Operating Systems Security
- Apple Hardware
- Laptops & Notebooks
- Servers
- Networking Hardware
- Peripherals
- Devices
- Displays / Monitors
- WebTrends / Stats
- Search Engines
- Firewalls
- WebApplications
- IDS
- Vulnerabilities
- Email Clients
- File Sharing
- Spy / Ad Blockers
- Web Browsers
- Web Servers
- Networking
- Anti-Virus
- Chat / IM
- Anti Spam
| Developer |
- Web Servers
- Web Browsers
- Game Programming
- Dev Tools
- Industry Specific
- Office / Productivity
- Database
- CYGWIN
- Web Development
- Search Engines
- File Sharing
- WebTrends / Stats
- Programming
- Content Management
- Application Servers
- Protocols
| Storage |
- Removable Backup Media
- Storage Technology
- Servers
- Grid
- Remote Access
- Backup / Restore
- Misc
- Hard Drives
| OS |
- Miscellaneous
- Security
- Development
- Linux
- VMWare
- MainFrame OS
- Unix
- Apple
- OS / 2
- AS / 400
- BeOS
- Microsoft
- VMS / OpenVMS
| Database |
- Oracle
- Miscellaneous
- MySQL
- Software
- Sybase
- Contact Management
- PostgreSQL
- Data Manipulation
- Clarion
- InterSystems Cache
- Siebel
- MUMPS
- OLAP
- SQLBase
- SAS
- GIS & GPS
- 4GL
- Berkeley DB
- DB2
- Informix
- Interbase / Firebird
- FoxPro
- Reporting
- LDAP
- Filemaker Pro
- MS SQL Server
- dBase
- MS Access
| Security |
- Misc
- Web Browsers
- Software Firewalls
- Operating Systems Security
- File Sharing
- Spy / Ad Blockers
- Vulnerabilities
- WebApplications
- IDS
- Anti-Virus
- Encryption
- Anti Spam
- Email Clients
- VPN
- Chat / IM
| Programming |
- Editors IDEs
- Installation
- Handhelds / PDAs
- Multimedia Programming
- System / Kernel
- Algorithms
- Game
- Signal Processing
- Project Management
- Open Source
- Database
- Misc
- Languages
- Processor Platforms
- Theory
| Web Development |
- Scripting
- Blogs
- Web Servers
- Software
- Search Engines
- Web Graphics
- Images
- Internet Marketing
- Images and Photos
- Components
- Document Imaging
- Web Languages/Standards
- Illustration
- WebApplications
- Fonts
- WebTrends / Stats
- Authoring
- Digital Camera Software
- Miscellaneous
| Networking |
- Protocols
- Apple Networking
- Network Management
- Message Queue
- Application Servers
- Content Management
- File Servers
- Email Servers
- Misc
- Java Editors & IDEs
- Wireless
- Networking Hardware
- Backup / Restore
- System Utilities
- ISPs & Hosting
- Web Servers
- Storage Technology
- Removable Backup Media
- Servers
- Broadband
- Grid
- OS / 2
- Novell Netware
- Unix Networking
- Windows Networking
- Security
- Telecommunications
- Operating Systems
- Linux Networking
| Other |
- Community Advisor
- Lounge
- Community Support
- New Net Users
- Philosophy / Religion
- Math / Science
- Miscellaneous
- URLs
- Expert Lounge
- Politics
- Puzzles / Riddles
| Community Support |
- Suggestions
- New to EE
- New Topics
- Community Advisor
- CleanUp
- Announcements
- General
- Feedback
- Input
- EE Bugs
| 05.09.2008 at 07:54AM PDT, ID: 21533466 |
Project can't display the dates as numbers. You could write some formulas and use custom fields to show these numbers, though. Whether the formula counts weekends (or holidays) depends on how sophisticated you want to get.
In Project 2007, go to Tools -> Customize-> Fields...
Select Task, Type: Number and choose an unused field. "Rename..." to give the field a name, such as "Days from start"
Choose Formula, and enter
DateDiff("d",[Project Start],[Start])
(Date difference in days of project start and the task start)
Click OK, OK,
Now you can insert this column into your views.
(The formula above counts weekends. These are essentially VBA formulas, similar to what Excel uses, so internet searches for more sophisticated formulas should give plenty of results.)
James Fraser
In Project 2007, go to Tools -> Customize-> Fields...
Select Task, Type: Number and choose an unused field. "Rename..." to give the field a name, such as "Days from start"
Choose Formula, and enter
DateDiff("d",[Project Start],[Start])
(Date difference in days of project start and the task start)
Click OK, OK,
Now you can insert this column into your views.
(The formula above counts weekends. These are essentially VBA formulas, similar to what Excel uses, so internet searches for more sophisticated formulas should give plenty of results.)
James Fraser
| 05.16.2008 at 08:25AM PDT, ID: 21583577 |
Hmmm when I try to insert it I get a value of 0.01 when I have the starting task at 1 day and task B at 8 days. For task C (Duration 1 day) I get a value of 0.03.
Mistake in the code or am I not implementing it correctly?
Mistake in the code or am I not implementing it correctly?
| 05.16.2008 at 09:40AM PDT, ID: 21584267 |
Make sure you have "d" as the first part of datediff, for days. Sounds like you might have something else.
James Fraser
James Fraser
| 05.16.2008 at 01:59PM PDT, ID: 21586387 |
copied and pasted...same result.
Any problem you think if I'm using Project 2007?
Oh also I'm looking at the network diagrams, not sure if I mentioned that.
Any problem you think if I'm using Project 2007?
Oh also I'm looking at the network diagrams, not sure if I mentioned that.
| 05.16.2008 at 02:15PM PDT, ID: 21586512 |
I created and tested this in 2007. I just recreated everything, and am attaching a screenshot. What is your date format set to? I wonder if there is a bug related to that?
James Fraser
James Fraser
20080236-EE-VQP-29 / EE_QW_2_20070628
