Count The Number of days

I have two queries to post both are related

I have a coulum D where i put the dates, and in the next coulmn E I put this formula "=MONTH(D2)" and drag it till the end, it gives me the moth of that date for eg if i put 01/09/2010 in coulumn E2, D2 will give me the value ' 9 '. I want that to show up as September. Is that possible????????

second question is i have dates going down in column E, one date is repeated around 15 to 16 times and it might vary, so i want a formula to count the number of days., I might come up with a few more questions after i get the results for this

Thanking you in adavnce

a) Instead of =MONTH(D2) you can write =D2 and format cell as mmmm

b) post some example what you trying to to and how your output should look like

The first question is cleared now the second part I have the same dates repeating likei will show you example
01/09/2010
01/09/2010
01/09/2010
01/09/2010
02/09/2010
02/09/2010
02/09/2010
02/09/2010
03/09/2010
03/09/2010
03/09/2010
03/09/2010 Here i have just added 4 times,but in the real time it will be more than that,so at any point of time when i generate the report i want to know the Number of days in this report,In the example, it is for 3 days from 1st to 3rd. I hope I have explained correctly

=(max(dates)-min(dates))+1

+ 1 gives an inclusive figure

edvwvw

I am having the dates on Sheet two, column D and i want the number of days in Sheet 1, Is that possible???

=(MAX(Sheet2!D2:D26)-MIN(Sheet2!D2:D26))+1

the dates in column D sheet 2

format the result cell as number

edvwvw

There is a problem there, I have the data pasted on to sheet two on a dialy basis, so there will be dates from last month and this month, I am trying to find out the number of days for a pirticular month, not from the last month and i think it also counts the week ends, even if the date is not mentioned on the sheet 2

wish2excel

It is important that you state your request precisely - if you constantly "move the goal posts" the people on here who volunteer their time will be reluctant to help.

It is possible to achieve the work days and also by month totals but I haven't got time to assist you at the moment

edvwvw