days of the week formulas
On Thu, 6 Mar 2008 11:02:04 -0800, Bob wrote:
I'm looking for formulas that will give me the first Monday and last Sunday
of a period. For example The First Monday of February 2008 would be February
4 and the last Sunday would be March 2. Add x number of days to the formulas
to give me the first Monday in April 2008 as April 7 and the last Sunday as
May 4.
What is your definition of a "period"?
With any date in A1, the first Monday of the month of that date is given by the
formula:
=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1)+6)
But I don't know how you are computing the "end of the period".
--ron
|