ExcelBanter - Display Monday of each week

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Display Monday of each week (https://www.excelbanter.com/excel-discussion-misc-queries/192685-display-monday-each-week.html)

Eileen[_2_]

Display Monday of each week

I have a column with dates, and I need to return the Monday of that week. For
example, I need a simple forumular to return 6/23 (Monday) when I enter 6/25
(Thursday).

Can someone help please ?

Thanks !

T. Valko

Display Monday of each week

Try this:

=A1-WEEKDAY(A1,2)+1

--
Biff
Microsoft Excel MVP

"Eileen" <Eileen @discussions.microsoft.com wrote in message
...
I have a column with dates, and I need to return the Monday of that week.
For
example, I need a simple forumular to return 6/23 (Monday) when I enter
6/25
(Thursday).

Can someone help please ?

Thanks !

Ron Rosenfeld

Display Monday of each week

On Wed, 25 Jun 2008 23:05:00 -0700, Eileen <Eileen @discussions.microsoft.com
wrote:

I have a column with dates, and I need to return the Monday of that week. For
example, I need a simple forumular to return 6/23 (Monday) when I enter 6/25
(Thursday).

Can someone help please ?

Thanks !

=A1+1-WEEKDAY(A1-1)
--ron

All times are GMT +1. The time now is 12:41 PM.