Adding 30 working days to a date

Good morning!

I'm trying to add 30 working days to a formula. I tried a simple formula and it wasn't working. I tried =weekday(y8,30) and the result came back #NUM!

I'm trying to:

y8 has a date reference & I need to add 30 working days to that date in
cell z8 as a due date.

At the same time, I would like cell z8 to remain blank until the y8 date has been entered.

Can someone please help me figure out the formula?

Thanks,
Dawn

Try the Workday() function.. It is an analysis toolpak function so you have to have it installed... go to Tools|Options|Addins and make sure Analysis Toolpak is checked.

Then try:

=IF(Y8="","",WORKDAY(Y8,30))

Originally Posted by Dawn V

NBVC...

Thank you VERY much! That worked!

~Dawn

PS... Updated baby picture is ADORABLE!

You are welcome... and Thank You!