ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to find the number of days from 2 dates? (https://www.excelbanter.com/excel-discussion-misc-queries/94347-how-find-number-days-2-dates.html)

cyberdude

How to find the number of days from 2 dates?
 
Hi,

I have 2 dates, say 24/5/2003 and 26/7/2004 and I would like to count
the number of days from 24/5/2003 to 26/7/2004. How can I do it with
Excel? Thanks.

David


Arvi Laanemets

How to find the number of days from 2 dates?
 
Hi

=B1-A1, where earlier day is in A1


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"cyberdude" wrote in message
oups.com...
Hi,

I have 2 dates, say 24/5/2003 and 26/7/2004 and I would like to count
the number of days from 24/5/2003 to 26/7/2004. How can I do it with
Excel? Thanks.

David





All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com