ExcelBanter - setting the date to monday

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - setting the date to monday (https://www.excelbanter.com/excel-worksheet-functions/165081-setting-date-monday.html)

Mortir

setting the date to monday

is there a way the i could create a formula that would check the
current date and then set the date to monday of the week.

examples:
on date 07.Nov 07. The formula would give me 05.nov 07 (monday)
on date 23. Nov 07. The formula would give me 19.nov 07(monday)

carlo

setting the date to monday

On Nov 7, 4:27 pm, Mortir wrote:
is there a way the i could create a formula that would check the
current date and then set the date to monday of the week.

examples:
on date 07.Nov 07. The formula would give me 05.nov 07 (monday)
on date 23. Nov 07. The formula would give me 19.nov 07(monday)

=NOW() - WEEKDAY(NOW(),3)

NOW = Date today
WEEKDAY = monday:0, tuesday:1 and so on

hth

Carlo

ryguy7272

setting the date to monday

Last Monday:
=TODAY()-WEEKDAY(TODAY())+2

Next Monday:
=TODAY()+6-MOD(WEEKDAY(TODAY())+4,7)
=TODAY()-WEEKDAY(TODAY()-2)+7
=TODAY()-WEEKDAY(TODAY(),2)+8

Regards,
Ryan---
--
RyGuy

"carlo" wrote:

On Nov 7, 4:27 pm, Mortir wrote:
is there a way the i could create a formula that would check the
current date and then set the date to monday of the week.

examples:
on date 07.Nov 07. The formula would give me 05.nov 07 (monday)
on date 23. Nov 07. The formula would give me 19.nov 07(monday)

=NOW() - WEEKDAY(NOW(),3)

NOW = Date today
WEEKDAY = monday:0, tuesday:1 and so on

hth

Carlo

All times are GMT +1. The time now is 11:27 PM.