| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working out a date for a fixed day of the week
Hi
Hope you can help. I need a formula (is is conditional formatting?) that calculates the date of the preceding Monday from a subsequent known date of delivery. For example: delivery is need for Friday 30th Nov 2007. What is the date of the preceding Monday? thanks Matt |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
working out a date for a fixed day of the week
=A2-WEEKDAY(A2,2)+1
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Matt Sharman" wrote in message ... Hi Hope you can help. I need a formula (is is conditional formatting?) that calculates the date of the preceding Monday from a subsequent known date of delivery. For example: delivery is need for Friday 30th Nov 2007. What is the date of the preceding Monday? thanks Matt |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
working out a date for a fixed day of the week
=A1-MOD(A1-2,7)
"Matt Sharman" wrote: Hi Hope you can help. I need a formula (is is conditional formatting?) that calculates the date of the preceding Monday from a subsequent known date of delivery. For example: delivery is need for Friday 30th Nov 2007. What is the date of the preceding Monday? thanks Matt |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
working out a date for a fixed day of the week
Careful - this returns an erroneous date if the user is using the 1904
Date system. Better: =A1+1-WEEKDAY(A1,2) In article , Teethless mama wrote: =A1-MOD(A1-2,7) "Matt Sharman" wrote: Hi Hope you can help. I need a formula (is is conditional formatting?) that calculates the date of the preceding Monday from a subsequent known date of delivery. For example: delivery is need for Friday 30th Nov 2007. What is the date of the preceding Monday? thanks Matt |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
working out a date for a fixed day of the week
Thanks Guys. Fantastic response. Great help!
-- Director of Cantifix of London Limited "Matt Sharman" wrote: Hi Hope you can help. I need a formula (is is conditional formatting?) that calculates the date of the preceding Monday from a subsequent known date of delivery. For example: delivery is need for Friday 30th Nov 2007. What is the date of the preceding Monday? thanks Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
| Count working days by week | Excel Worksheet Functions | |||
| auto working week-ending date for timesheet | Excel Worksheet Functions | |||
| Line Chart with dates in 5 day working week only | Charts and Charting in Excel | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
