Weekday function +1 day

[realniceguy5000]

Hi have this formula in a cell. But I noticed it doesn't work if the day is friday because the next working day would be Monday.

I tried to replace the Today with weekday but I'm not doing something right.

Please Login or Register  to view this content.

Can someone help?

Thank You, Mike

[DonkeyOte]

If you activate the Analysis ToolPak you can make use of the WORKDAY function, eg

Please Login or Register  to view this content.

there is an optional public holiday parameter with WORKDAY see XL Help files for more info

non-ATP use a LOOKUP based on weekday but of course you may still need to account for public holidays.

Please Login or Register  to view this content.

[realniceguy5000]

Thank You, That is something I also overlooked was holidays.

Mike,