calculating weekday date

K

Khardy3352

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. :)
 
R

Ron Rosenfeld

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. :)
Click to expand...


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
 
K

Khardy3352

Excellent! Thank you!!!
Ron Rosenfeld said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2016 Project, adding a workday to custom field 0
Next weekday ... 3
Days between 2 dates excluding Sundays only 1
Counting depending on another column 4
Adding days to the WORKDAY function 2
Offset depending on date 2
Help to Highlight Excel Row based on Weekly Date Range 2
Date Calculation - Astro Calculation 0

Top