View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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