Search : in
By :

Adding Dates

Last answer on Oct 30, 2009 5:56:23 am GMT Rachel, on Oct 28, 2009 2:53:26 pm GMT 
 Report this message to moderators

Hello,
I am trying to find a formula that calculates dates. Like I have two boxes with a beginning and date in them, and I want to calculate the days between. Example - Work dates 10/1/09 - 10/3/09 and I want a formula that calculates that it equals a total of 3 days. Can I do that?

Configuration: Windows XP
Firefox 3.0.15

Best answers for « Adding Dates » in :
Adding data from one column using another Show Adding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
How to make database connectivity in asp.net Show
Changin format of date in excel Show
Conversion of an IP address 32-bit ShowConversion of an IP address 32-bit We will make a ping kioskea.net in view retrieve the IP address (in bold) $ Ping-c1 kioskea.net PING kioskea.net (194,169,240,130) 56 (84) data bytes. 64 bytes from www.kisokea.org...
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...
Download Access Data Transfer Assistant 2000 ShowAccess Data Transfer Assistant 2000 is a program which allows you to transfer data between two Access databases. It lets you add data to the existing data of the destination database or to replace the data by those from the source database. It...
Download PDF Page Resizer ShowPDF Page Resizer does not allow PDF pages on a new type of paper. It is a very practical tool to maintain your PDF files. It allows to modify or to add data to information fields of one or several PDF files. The data can be printed to a standard...
Download TimeToPhoto ShowTimeToPhoto is a utility which allows you to add datestamps to your photo. All you have to do is to select your photos and click on “Run” and the rest will be done automatically. TimeToPhoto will add the date and time by using EXIF data contained...
NAT- Network address translation, port forwarding and port trigg ShowThe principle of NAT Network address translation or NAT was developed in order to respond to the shortage of IP addresses with IPv4 protocol (in time the IPv6 protocol will respond to this problem). In fact, in IPv4 addressing the number of...
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...
IP Address ShowWhat is an IP address? Computers communicate over the Internet using the IP protocol (Internet Protocol), which uses numerical addresses, called IP addresses, made up of four whole numbers (4 bytes) between 0 and 255 and written in the format...
Ask your question Reply

1

 Excelguru, on Oct 30, 2009 5:56:23 am GMT

Hello

If you have the dates in A1 & B1 and then in C1 put =B1-A1+1
Excel considers the date as a number A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

   
Reply to Excelguru
Ask your question Reply
They need your help