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. |
=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 |
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 |
All times are GMT +1. The time now is 10:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com