Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2020, 09:32 AM
powergc powergc is offline Now() Function Not Updating in MS Project Windows 10 Now() Function Not Updating in MS Project Office 2016
Novice
Now() Function Not Updating in MS Project
 
Join Date: Dec 2020
Posts: 1
powergc is on a distinguished road
Default Now() Function Not Updating in MS Project

Hello,




I am new to working with MS Project, so please bear with me


I am trying to create a column that will give the days from now until the end of the task. So, essentially number of days from today to task finish date.


I inserted a new column and added the following formula:
DateDiff("d",NOW(),[Finish])


This seems to work, however, when I open the document the next day, the column doesn't automatically update. So I have to right click on the column, select custom fields, and select the formula button. I don't have to re-enter the formula, at this point, I just have to click OK and it will update.


I was hoping that this would work like the Today() function in excel and update each time that the document is opened.


Any tips that anyone is able to share would be greatly appreciated!
Reply With Quote
  #2  
Old 01-12-2021, 09:37 AM
miless2111s miless2111s is offline Now() Function Not Updating in MS Project Windows 7 32bit Now() Function Not Updating in MS Project Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

that seems odd. Could you use [status date] instead which would give you control of that date which is used...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Project task numbering changed after linking item in subproject to m aster project rrs_2017 Project 0 09-06-2017 06:07 AM
Microsoft Project Server, Microsoft Project Online and Project Web App - Whats the difference? chocolateCupcakes Project 1 02-11-2017 12:25 PM
Now() Function Not Updating in MS Project Restrict Editing function disable insert textbox function IanM_01 Word 5 11-21-2015 02:29 AM
Now() Function Not Updating in MS Project #REF! Error in calling VBA function disappears when function is copied lcaretto Excel Programming 2 05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function) bmoody Excel 2 11-06-2013 10:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 PM.


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