Search : in
By :

Count date

Last answer on May 28, 2009 10:07:23 am BST niwa, on May 28, 2009 7:40:57 am BST 
 Report this message to moderators

Hello,
i want count the date for data range pls give me a formula
ex 02/05/09- 03/05/09 count 2 day

Configuration: Windows XP
Firefox 3.0.5

Best answers for « count date » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...

1

 mubashir aziz, on May 28, 2009 10:07:23 am BST

Suppose you Start Date is in A1 and Finish Date in B1 then formula in C1 will be

C1 = (B1-A1)+1 and make sure to change the cell format of C1 as General or number format

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

Reply to mubashir aziz