| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Calculate # of Days from one date to another
May be a simple question, but how to I calculate the number of days from Jan
1, 2004 to a another specific date? Thanks. |
|
#2
|
|||
|
|||
|
=DATEDIF(C8,D8,"d") c8, d8 are dates, note that D8 should be greater than c8 -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=277226 |
|
#3
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
| subtracting 30 days from any date. | Excel Discussion (Misc queries) | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
| How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
| Calculate age as of a date certain | Excel Discussion (Misc queries) | |||
Hybrid Mode
