Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
set month end
Hi. I need a function to customize month end to the last Friday of each
month. So for December 2005, the start date would be (A1) 11-26-05, and the end date would be (A2) 12-30-05. I want to autofill the dates that fall within this range down starting in A3. Any thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
set month end
=IF(MONTH(A2+28)=MONTH(A2+35),A2+35,A2+28)
There will be either 4 weeks(28 days) or 5 weeks (35 days) between month end. so if 4 weeks later is in the same month as 5 weeks later, then it is 5 weeks, if they're different, it's 4 weeks. - Search "Chilliputt" wrote: Hi. I need a function to customize month end to the last Friday of each month. So for December 2005, the start date would be (A1) 11-26-05, and the end date would be (A2) 12-30-05. I want to autofill the dates that fall within this range down starting in A3. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
formula: First and last day in month | Excel Worksheet Functions | |||
Referencing data in different worksheet based on month name | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) |