Rogers formula uses exactly same logic as formula I gave you so expect same
issue will apply (but I think it's a slick way of doing it).

Suspect your date isn't formatted as date.
--
Email: subst1tut3 numb3rs for l3tt3rs...


"Roger Govier" wrote:

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