| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting days in month
Hi James
Assuming you have the Analysis Toolpak loaded (ToolsAddinsAnalysis Toolpak), then you can use the Eomonth() function. With Start date in A1, End Date in B1 days in May =EOMONTH(A1,0)-A1+1 days in June =B1-EOMONTH(A1,0) Format the cells containing the formula as General. Both formulae assume that you are counting the whole of the start date and the whole of the end date -- Regards Roger Govier "jamesjohn" wrote in message ... How can I separate days into different months and count them ? If I have a date of arrival and a date of departu 17/05/2006 to 22/06/2006 how can I count the numberof days in May and the number of days in June and have them separated ? Thanks in advance. -- jamesjohn ------------------------------------------------------------------------ jamesjohn's Profile: http://www.excelforum.com/member.php...fo&userid=9692 View this thread: http://www.excelforum.com/showthread...hreadid=545300 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Desperately trying to build a paid time off accrual worksheet... | Excel Worksheet Functions | |||
| challenging formula(for me), counting days between dates for multipleyears | Excel Worksheet Functions | |||
| Calculate Days in a Month | Excel Discussion (Misc queries) | |||
| Counting Entries by Month and Year | Excel Worksheet Functions | |||
| Counting days and Configurations together | Excel Worksheet Functions | |||
Threaded Mode
