formula does not recognize value

V

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?
 
H

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
 
V

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!
 
H

Harald Staff

Frank Kabel said:
Hi Harald
you probably meant WORKDAY and not WEEKDAY
Click to expand...

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

Best wishes Harald
 
Top