Hi Bob

That's fine apart from April and July where the result is the 17th,
which is further away from the 15th than the Friday (14th).

As the OP said it could be the Friday before the weekend, I took it to
mean he wanted the date which was the closest to the 15th.

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
Another way

=workday(A1+13,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Roger Govier" wrote in message
...
Hi

with start date in A1
=A1+14+CHOOSE(WEEKDAY(A1+14,2),0,0,0,0,0,-1,1)
will give the weekday that is closest to the 15th of the month.
--
Regards

Roger Govier


"Sunnyskies" wrote in message
...

Sorry Jon does not work, returns the same date as my opening date.

"Jon von der Heyden" wrote:

Hi,

Try: =IF(WEEKDAY(B3,2)=7,B3+1,IF(WEEKDAY(B3,2)=6,B3-1,B3))
Where B3 houses the date.
--
Email: subst1tut3 numb3rs for l3tt3rs...


"Sunnyskies" wrote:

Morning,

Scenario. Have got an opening date say the 2006-10-01 now I want
another
date - closing date the 2006-10-15 but if this closing date
falls
into a
weekend then I want the next working day to be shown. The
closing
date must
always be around the 15th of the month, but not on weekends (if
so
it can
then be on the Monday or preceeding Friday) as mentioned above.

My formula for closing date is currently =EOMONTH(C6,0) with is
showing
2006-10-31, how can I modify this to meet my requirement
mentioned
above.

Thanks