ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   calculating (https://www.excelbanter.com/new-users-excel/146173-calculating.html)

tofimoon4 via OfficeKB.com

calculating
 
My dear , can you tell me how to calculate values between two dates ( with
example if is it possible) .

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200706/1


Niek Otten

calculating
 
All about calculating with dates:

http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"tofimoon4 via OfficeKB.com" <u34725@uwe wrote in message news:7397bd146b157@uwe...
| My dear , can you tell me how to calculate values between two dates ( with
| example if is it possible) .
|
| --
| Message posted via OfficeKB.com
| http://www.officekb.com/Uwe/Forums.a...l-new/200706/1
|



Stan Brown

calculating
 
Tue, 12 Jun 2007 14:54:48 GMT from tofimoon4 via OfficeKB.com <u34725
@uwe:
My dear , can you tell me how to calculate values between two dates ( with
example if is it possible) .


Darling,

Put one date in A1 and the other in A2. Put this formula in A3:
=A2-A1

And please don't post the same query twice.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/


All times are GMT +1. The time now is 09:12 PM.

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