| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculating weekday date
I need to calculate a date 10 days from a start date that, if the final date
is a Sat, the result defaults to the previous Fri, or, if the final date is a Sun, the result defaults to a Mon. Is this possible? I use 2003. Thanks for your help. In your response, remember I am a novice and need a little extra explanation. :) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculating weekday date
On Tue, 10 Jun 2008 19:23:01 -0700, Khardy3352
wrote: I need to calculate a date 10 days from a start date that, if the final date is a Sat, the result defaults to the previous Fri, or, if the final date is a Sun, the result defaults to a Mon. Is this possible? I use 2003. Thanks for your help. In your response, remember I am a novice and need a little extra explanation. :) With your original date in A1: =A1+10+(WEEKDAY(A1+10)=1)-(WEEKDAY(A1+10)=7) or, a bit more obscure, but shorter: =A1+10+(WEEKDAY(A1)=5)-(WEEKDAY(A1)=4) --ron |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculating weekday date
Excellent! Thank you!!! "Ron Rosenfeld" wrote: On Tue, 10 Jun 2008 19:23:01 -0700, Khardy3352 wrote: I need to calculate a date 10 days from a start date that, if the final date is a Sat, the result defaults to the previous Fri, or, if the final date is a Sun, the result defaults to a Mon. Is this possible? I use 2003. Thanks for your help. In your response, remember I am a novice and need a little extra explanation. :) With your original date in A1: =A1+10+(WEEKDAY(A1+10)=1)-(WEEKDAY(A1+10)=7) or, a bit more obscure, but shorter: =A1+10+(WEEKDAY(A1)=5)-(WEEKDAY(A1)=4) --ron |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculating weekday date
On Tue, 10 Jun 2008 20:36:00 -0700, Khardy3352
wrote: Excellent! Thank you!!! "Ron Rosenfeld" wrote: You're welcome. Glad to help. Thanks for the feedback. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert weekday date to the next sunday date | Excel Worksheet Functions | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| MATCHING DATE TO A WEEKDAY | Excel Worksheet Functions | |||
| Weekday formula calculating to end of month | Excel Worksheet Functions | |||
| Show Weekday with date??? | Excel Discussion (Misc queries) | |||
Linear Mode
