Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date to Monday's date within its week?
How do I convert a date (from cell A1) to Monday's date within its week into
cell B1? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date to Monday's date within its week?
One way:
=1-WEEKDAY(A1,2)+A1 -- Biff Microsoft Excel MVP "Sorsy" wrote in message ... How do I convert a date (from cell A1) to Monday's date within its week into cell B1? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date to Monday's date within its week?
This really helps, I learn something new. Thanks!
"Mike H" wrote: 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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date to Monday's date within its week?
This really helps. Thanks!
"T. Valko" wrote: One way: =1-WEEKDAY(A1,2)+A1 -- Biff Microsoft Excel MVP "Sorsy" wrote in message ... How do I convert a date (from cell A1) to Monday's date within its week into cell B1? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date to Monday's date within its week?
This really helps. Thanks!
"Ron Rosenfeld" wrote: 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert a date to Monday's date within its week?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Sorsy" wrote in message ... This really helps. Thanks! "T. Valko" wrote: One way: =1-WEEKDAY(A1,2)+A1 -- Biff Microsoft Excel MVP "Sorsy" wrote in message ... How do I convert a date (from cell A1) to Monday's date within its week into cell B1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to return next Monday's date | Excel Worksheet Functions | |||
Convert Week Number to Date | Excel Discussion (Misc queries) | |||
Given today's date, I want this week's Monday's date | Excel Worksheet Functions | |||
How do I convert a date to a week of the year? | Excel Discussion (Misc queries) | |||
Display Monday's date only on x-axis | Charts and Charting in Excel |