| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date calculation for Monday of one month to the Monday of the next | Excel Discussion (Misc queries) | |||
| HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007) | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| adding day (sunday, Monday) to date | Excel Worksheet Functions | |||
| Date to a day (Monday, Tue, etc?) | Excel Discussion (Misc queries) | |||
Linear Mode
