 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Calculating days
I have dates like 29 March to 5 May how do i calculate the number of days Just subtract the earlier from the later and format the cell as General or Number. Hope this helps. Pete > I have dates like 29 March to 5 May how do i calculate the number of days Just to add to Pete's post, if you want to count both the dates 29 March and 5 May, append +1 to the end of the subtraction. ie: A1= 29/03/08 A2=5/05/08 =A2-A1+1 gives 38  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk Just subtract the earlier from the later and format the cell as General or Number. Hope this helps. Pete On Mar 26, 1:04 pm, james <p...@commey.msn.com> wrote: > I have dates like 29 March to 5 May how do i calculate the number of days
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.