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