Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days in a specific month
Hi all,
I hve noted there are documented ways to calculate the number of weekdays in any month, but my enquiry is somewhat different. I have 5000 rows, with two columns [actual_start] and [actual_end] for my date ranges, which invariably stay within a calendar month. Easy enough to calculate the number of weekdays between the two dates ( NETWORKDAYS() ). But, if the two dates go between say 27-Aug-09 and 3-Oct-09, I only want to know the number of weekdays in September. is this possible, and can anyone advise? TIA Pete |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days in a specific month
If you could post *several* representative samples and the expected results
it would help. -- Biff Microsoft Excel MVP "DubboPete" wrote in message ... Hi all, I hve noted there are documented ways to calculate the number of weekdays in any month, but my enquiry is somewhat different. I have 5000 rows, with two columns [actual_start] and [actual_end] for my date ranges, which invariably stay within a calendar month. Easy enough to calculate the number of weekdays between the two dates ( NETWORKDAYS() ). But, if the two dates go between say 27-Aug-09 and 3-Oct-09, I only want to know the number of weekdays in September. is this possible, and can anyone advise? TIA Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days in a specific month
If you have to select the middle month from a 3 months period (like 09 from
08,09,10 in your example) then =NETWORKDAYS(IF(MONTH(A1)<MONTH(B1);DATE(YEAR(B1); MONTH(B1)-1;1);A1);IF(MONTH(A1)<MONTH(B1);DATE(YEAR(B1);MONT H(B1);0);B1)) Regards, Stefi €žDubboPete€ť ezt Ă*rta: Hi all, I hve noted there are documented ways to calculate the number of weekdays in any month, but my enquiry is somewhat different. I have 5000 rows, with two columns [actual_start] and [actual_end] for my date ranges, which invariably stay within a calendar month. Easy enough to calculate the number of weekdays between the two dates ( NETWORKDAYS() ). But, if the two dates go between say 27-Aug-09 and 3-Oct-09, I only want to know the number of weekdays in September. is this possible, and can anyone advise? TIA Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of days in a specific month between various start and end d | Excel Worksheet Functions | |||
excel to make the days cary over month to month automaticly | New Users to Excel | |||
Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | Excel Discussion (Misc queries) | |||
Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
Days per month for calculating storage days | Excel Worksheet Functions |