| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to find each day prior to first friday, monthly
I'm not sure what mean by "selecting all the days of the month prior to the
first Friday." But for a given date in A1, you can calculate the first Friday of the month as =A1-DAY(A1)+CHOOSE(WEEKDAY(A1-DAY(A1)),5,4,3,2,1,7,6). The approach in that formula is to add an appropriate number of days to the last day of the prior month. HTH. --Bruce "PaulRMcHanJr" wrote: I am trying to create a calendar with a "grace period" that ends on the first friday of each month. I can identify the first friday: =AND(WEEKDAY(A1)=6,DAY(A1)<=7) and the first week: =AND(DAY(A1)<=7) but can't get my mind around selecting all the days of the month prior to the first friday... Thanks, Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
| Find Function | Excel Discussion (Misc queries) | |||
| I have a list of numbers (bus miles) I want to find the monthly a. | Excel Discussion (Misc queries) | |||
| Date Calculations | Excel Worksheet Functions | |||
Threaded Mode
