ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculate # of Days from one date to another (https://www.excelbanter.com/excel-worksheet-functions/6166-calculate-days-one-date-another.html)

jscano

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.

anilsolipuram


=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


Ron Rosenfeld

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