Thread: How do I convert a date to Monday's date within its week?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How do I convert a date to Monday's date within its week?
Try this in b1

=IF(WEEKDAY(A1)=1,A1-6,A1-(WEEKDAY(A1)-2))

Mike

"Sorsy" wrote:

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