formula does not recognize value

[Vato Loco]

i have a workbook that calculates exp dates. When the date lands on a
saturday or sunday, I want it to bump out to the following monday.

How can I do this?

 

[Harald Staff]

Make your formula consider the WEEKDAY result of its own calculation and add
1 ot 2 according to that.

HTH. Best wishes Harald

 

[mzehr]

Hi Vato,

Try,

WORKDAY(start_date,days,holidays)

HTH

 

[Vato Loco]

would that be in the formatting?

example : =($D$1+B11)

how would I make that jump to the workday?

sorry, I'm not real good at the formulas!!

And thanks!

 

[Frank Kabel]

Hi
use
=WORKDAY($D$1,B11)

 

[Frank Kabel]

Hi Harald
you probably meant WORKDAY and not WEEKDAY

 

[Harald Staff]

Hi Harald
you probably meant WORKDAY and not WEEKDAY

I see your point, but no. I never touch the ATP functions <g>

Best wishes Harald