ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   function (https://www.excelbanter.com/excel-discussion-misc-queries/168320-function.html)

Excel

function
 
how can i count the days between 2 dates

Mike Rogers[_2_]

function
 
excel

To start with you would just subtract the two dates. Need more information
to give a more complete answer.

Mike Rogers

"excel" wrote:

how can i count the days between 2 dates


Fred Smith

function
 
=A1-B1

--
Regards,
Fred


"excel" wrote in message
...
how can i count the days between 2 dates




Stephen[_2_]

function
 
To add to the answers you have already received, if the two dates are
already in A1 and B1 when you enter the formula, Excel will try to format
the formula cell as a date. Simply reformat as General or a number.

"Fred Smith" wrote in message
...
=A1-B1

--
Regards,
Fred


"excel" wrote in message
...
how can i count the days between 2 dates







All times are GMT +1. The time now is 07:18 PM.

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