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 :
[PHP]Last day of the month/Number of days in the month ShowLast day of the month and number of days in a month Using $m as the number of the month i and $y as year. Function date() can display directly the number of days in the month using the "t" character:
How to count number of words in MS Words sheet! ShowHow to count number of words in MS Words sheet! It is quite simple to count the number of words in a Microsoft word sheet. This tip might be very useful for example, if you wish to make a presentation on Microsoft word for an approximate...
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Download Excel Viewer Show
Download Excel Password Recovery Master Show
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...
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
  • +12

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
  • +8

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