Thread: How do I convert a date to Monday's date within its week?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How do I convert a date to Monday's date within its week?
On Wed, 8 Oct 2008 13:10:01 -0700, Sorsy
wrote:

How do I convert a date (from cell A1) to Monday's date within its week into
cell B1?

What is the first day of the week?

If the first day is Monday, then:

=A1+1-WEEKDAY(A1+6)

If the first day is Sunday, (so the Monday would be the day after Sunday) then:

=A1+2-WEEKDAY(A1)
--ron
Reply With QuoteReply With Quote