Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2019, 03:22 PM
macropod's Avatar
macropod macropod is offline Calculate a Date Windows 7 64bit Calculate a Date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The reasons for the '24-1-5054' display, and its remedy, is clearly stated in the tutorial's introduction:


Quote:
In this document, the bookmarks used to create an example are often re-used in other examples. A side effect of this is that the calculated dates and times in the examples will display a result based on the last-bookmarked entry for each reference when this document is first opened. This can be corrected by updating the affected fields (by selecting the field and pressing F9, for example), and would not affect documents where the bookmark names are not re-used.
The instructions in post #2 tell you the only modifications you need to make to the Calculate a day, date, month and year, using n days delay example in the tutorial. Post #4 gives even more detailed instructions. There is nothing more to add.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
date calculations



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to use a date to calculate an amount $. melvin1942 Excel 13 05-22-2016 04:03 PM
calculate date if date entered in cell, do nothing if blank ConfuddledOne Excel 3 11-07-2014 09:37 AM
Formula to calculate Date and Time funkyfido Excel 2 06-25-2013 04:25 PM
Calculate a Date how to calculate backwards from a set finish date ketanco Project 1 02-07-2013 06:50 AM
Calculate a Date Calculate date in word field edwedw Mail Merge 3 11-30-2011 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 AM.


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