Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a the following matrix that I want to populate with the number of
Saturdays, Sundays, Mondays, etc. by month, which is based off of a daily Fiscal Year (i.e. FY 2010) calendar that begins with October 1, 2009 (40087) and ends with September 30, 2010 (40451) down column A of a tab titled "FY Calendar" When I change the Fiscal Year to 2011, 2012 I want the matrix repopulated with the corrrect count of each weekday. I already have the calendar built which displays each date down column B, the month in column C, the day of the week in column D and the Weekday (1-7) in column E. If there is an easier way to do all this I would appreciate the help. A B C D E F 1 Saturday Sunday Monday Tuesday Wednesday etc... 2 October 5 4 4 3 November 4 December 5 January 6 February 7 March 8 April 9 May 10 June 11 July 12 August 13 September |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Averaging Month & weekdays | Excel Discussion (Misc queries) | |||
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr | Excel Worksheet Functions | |||
Count number of row for Particular month | Excel Worksheet Functions | |||
Weekdays of the month. | Excel Discussion (Misc queries) | |||
How do i count number of weekdays between two dates? | Excel Worksheet Functions |