#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default 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
|


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 524
Default 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/
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating APY for CD Starlin Dotson New Users to Excel 3 May 18th 06 12:56 AM
Calculating Help metaltecks Excel Discussion (Misc queries) 2 March 28th 06 09:10 PM
Calculating % when 0 is 100% Alison Excel Worksheet Functions 3 February 23rd 06 06:05 PM
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM
calculating frank Excel Discussion (Misc queries) 4 February 9th 05 03:54 AM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"