Calculate # of Days from one date to another

Ron Rosenfeld

Posts: n/a

On Wed, 10 Nov 2004 15:09:02 -0800, jscano
wrote:

May be a simple question, but how to I calculate the number of days from Jan
1, 2004 to a another specific date?

Thanks.

=A1-B1

or

=A1 - DATE(2004,1,1)

Be sure to format the result as General (or Number).

--ron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I calculate EDATE using days not months?	pshift	Excel Discussion (Misc queries)	4	April 21st 23 09:02 AM
subtracting 30 days from any date.	help me	Excel Discussion (Misc queries)	1	December 17th 04 04:27 AM
How would I change a date cell to decrease it by business days?	CNGracin	Excel Discussion (Misc queries)	3	December 15th 04 05:20 PM
How do I use the IF function to calculate date	Pulling My Hair Out!	Excel Discussion (Misc queries)	1	December 10th 04 11:03 PM
Calculate age as of a date certain	Joe S.	Excel Discussion (Misc queries)	1	December 9th 04 09:02 PM

All times are GMT +1. The time now is 04:12 PM.

Menu

About Us