Search : in
By :

Count days in excel

Last answer on Jun 25, 2009 9:23:55 pm BST Filippos, on Oct 17, 2008 9:38:03 am BST 
 Report this message to moderators

Hello,

How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days.
with =NETWORKDAYS(A1,A2) not count the weekends.

Thanks
Filippos

Configuration: Windows XP
Firefox 3.0.3

Best answers for « count days in excel » in :
[Excel] – Countif Formula Show[Excel] – Countif Formula Issue Solution Note Issue I have one excel file in that Column "B" has the "pending or Closed" Status and Column "C" has "Severity 1, Severity 2 and Severity 3" I want to count in one cell with "Pending...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

stephen3326, on Oct 17, 2008 1:57:07 pm BST
  • +1

Hello,

just click on the link below and you will find many tips concerning excel :

http://www.techonthenet.com/excel/

   
Reply to stephen3326

2

Ivan-hoe, on Oct 17, 2008 3:06:46 pm BST

Hello Filippos,
a subtraction should work it out 

=A2-A1+1

Ivan

   
Reply to Ivan-hoe

3

Filippos, on Oct 20, 2008 6:33:06 am BST
  • +1

Thanks Ivan,

with this whenever the cells is empty indicate 1 and can't using SUM for the month

   
Reply to Filippos

4

DateMan, on Feb 21, 2009 3:22:51 am GMT
  • +6

Hi.

To count the number of days in a range is very simple.

Eg: i want to count the number of days between 1/1/9 and 22/4/9


If cell A1 is start date (1/1/9), and cell B1 is end date (22/4/9), and the result will appear in cell C1, then the formula in C1 is simply = B1-A1

But, the trick is, you have to format cell C1 to be a General Number with no decimals, otherwise is just returns another date format response. Result in this example is 111 days.

Hope this helps.

   
Reply to DateMan

5

paoel, on Feb 25, 2009 8:01:32 am GMT
  • +33

And how do I exclude the weekends and holidays?

   
Reply to paoel

6

taffu, on Mar 14, 2009 5:25:02 am GMT
  • +11

How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days.

   
Reply to taffu

7

 gidge, on Jun 25, 2009 9:23:55 pm BST
  • +7

Using =networkdays("range") will exclude weekends. to exclude holidays, you must create a list of holidays, name this list and reference it in the network days formula... =networkdays(A1:A2, holidays)

   
Reply to gidge
Ask your question Reply
They need your help