set month end

[Guest]

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?

 

[Guest]

=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