Windowssecrets.com, 2014. — 17 p.The attached document shows how to do a wide range of date and time calculations in Word, including:
Expressing dates with ordinal numbering (eg 1st of January 2000), with or without superscripting;
Adding or subtracting a number of years, months, weeks or days to a date;
Calculating the difference between two dates;
Converting between Gregorian and Julian Calendars;
Calculating dates for Easter - for the Gregorian and Julian Calendars;
Generating date sequences;
Using Date/Time calculations to vary/conditionally display text and images;
Adding or subtracting times
The tutorial also discusses how the fields can be adapted for use in forms and mailmerges.Contents:
Introductory notes.
Using this document.
Viewing and updating fields.
Date input/output formats.
Date field basics.
Date/Time field syntax.
The Date field.
The Createdate field.
The Savedate field.
The Printdate field.
The Time field.
Insert a date with ordinal numbering.
Julian day numbers, Gregorian and Julian calendars.
Convert a Gregorian calendar date to a Julian day number.
Convert a Julian day number to a Gregorian calendar date.
Convert a Julian day number to a Julian calendar date.
Convert a Julian calendar date to a Julian day number.
Convert a Gregorian calendar date to a Julian calendar date.
Convert a Julian calendar date to a Gregorian calendar date.
Find the day of the week of a Gregorian calendar date.
Convert a Julian day number or Julian date to a day of the week.
Find the day of the year for a given date.
Find the date for a given day of the year.
Automatically insert a past or future date.
Calculate a month, using n months delay.
Calculate a month and year, using N months delay.
Calculate a month and year, using N years delay.
Calculate a day, date, month and year, using n years delay.
Calculate a day, date, month and year, using n months delay.
Calculate a lease expiry date, using N months delay.
Calculate a day, date, month and year, using n days delay.
Calculate a day, date, month and year, using n weeks delay.
Calculate the day & date of the last or Nth-to-last day of a given month.
Calculate the day & date of the Nth day of next month.
Calculate the day & date of a given day of the week next month.
Calculate the day & date of a given day of the week, n days in advance.
Handling weekends and holidays in calculated dates.
Changing document dates during the course of a day.
Interactively calculate a past or future date.
Working with dates before 1 Jan 1901 or after 31 Dec 4095.
Date and time calculations in a MailMerge.
Date and time calculations in a Word form.
Date and time calculations in a table.
Express today’s date in fiscal year terms.
Calculate the # days difference between two dates.
Calculate the # years months & days difference between two dates.
Calculate whether a period has elapsed.
Interactively calculate a person’s age.
Calculate a stepped date.
Calculate a stepped date range.
Calculate a date sequence.
Calculate dates of Easter.
Use date (and/or time) comparisons to vary text.
Determine whether a document has expired.
Use a date test to provide pre-printing instructions.
Show or hide instructions & graphics at print time.
Vary instructions & prompts, based on Print/Save Dates.
Vary text in a document, based on Print/Save Dates and the user’s name.
Converting numeric date strings into word date formats.
Importing date and time values from excel and access.
Add or subtract two time periods.
Automatically calculate a past or future time of day.
Add N hours, minutes & seconds to a starting date & time.
