| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Figuring number of Mon. Tues. Wed between dates
It worked I changed the A151 to A2 which is where I have the end date. Thanks
so much. "T. Valko" wrote: One way... A1 = start date B1 = end date =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A151)),2)=2)) Where =2 means the 2nd day of the week = Tuesday -- Biff Microsoft Excel MVP "Paula" wrote in message ... Course begins January 1, 2008 Course ends May 30, 2008 How many Tuesdays are there. Of course the dates will change. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Figuring Age | Excel Worksheet Functions | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| In excel how set up a sequence to drag Mon, Tues, Wed Etc, | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Threaded Mode
