| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count monday tuesday between two date
i want to count how many manday, wednesday and friday in between two
different date in excel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count monday tuesday between two date
Assuming that A2 contains the start date, and B2 contains the end date,
try the following... To count the number of Mondays... =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)=1)) To count the number of Mondays, Wednesdays, and Fridays... =SUMPRODUCT(--ISNUMBER(MATCH(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2) ,{1,3,5}, 0))) Change the return type for the WEEDAY functions accordingly... Monday = 1 Tuesday = 2 Wednesday = 3 Thursday = 4 Friday = 5 Saturday = 6 Sunday = 7 Hope this helps! http://www.xl-central.com In article , Amit Kumar Singh <Amit Kumar wrote: i want to count how many manday, wednesday and friday in between two different date in excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date calculation for Monday of one month to the Monday of the next | Excel Discussion (Misc queries) | |||
| How to count by monday, tuesday, ...in a year? | Excel Discussion (Misc queries) | |||
| Calculating first/last Monday, Tuesday, etc. in a given month in E | Excel Worksheet Functions | |||
| Function to write Weekday - Monday, Tuesday etc | Excel Discussion (Misc queries) | |||
| How do I insert Sunday,Monday,Tuesday, etc. to repeat in nonadjac. | Excel Worksheet Functions | |||
Linear Mode
