Calculate number of days in a table from a specific date

tstolbert · #1 06-25-2016, 08:05 AM

Hi,

I was wondering if there is a way to calculate the number of days in a table from a specific date. I want it to update the number of days column when the word document is opened (if that is possible). Here is an example of what I am trying to do. If I could put a date picker in the date columns that would work then great or we can just type in a date.

This table is one of many in my word document.

DATE
IN SERVICE
UNIT ONE
DAYS
DATE
IN SERVICE
UNIT TWO
DAYS
CATION
06-20-16
5
6/25/2016
0
MIXED BED
06-10-16
15
6/23/2016
2

First column list types of resins used.
Second column list dates that each resin placed in service for Unit 1.
Third column list number of days that each resin has been in service from today for Unit 1.
Fourth column list dates that each resin placed in service for Unit 2.
Fifth column list number of days that each resin has been in service from today for Unit 2.

Thank you for your help.

Scott

Charles Kenyon · #2 06-25-2016, 01:56 PM

Date Calculation Tutorial
Be sure to read the introductory material.

tstolbert · #3 06-25-2016, 02:30 PM

Thank.

I will look at it.

I found this but not sure how to get it to work for me.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inserting a formula to count 30 days before and after a date in WORD table	bjh894	Word	9	05-18-2020 11:14 AM
How do I get auto-updated "number of days since specified date" on MS word?	terry795	Word	16	01-07-2016 04:33 PM
Is this possible? - Calculate and Display the date range between 2 specific dates	Premier-UK	Excel	2	08-18-2014 05:43 AM
Formula To Calculate Countdown Days To Project Completion	Catherine	Project	1	02-19-2014 11:15 AM
Calculate difference by days and hours	alysolyman	Excel	6	05-13-2013 02:19 AM