Formula to count back 30 working days

kelly.balmes53636

How do I create a formula to subtract 30 business days from a certain start date?

I was trying to use =WORKDAY ([start date]13, -30) and it's not working.  Note: the 13 is the row with the date I'm counting back from. 

Thanks for your help!

Paul Newcome

That formula should work. I just tested it myself. Is the column you are putting the formula in formatted as a Date Column?

kelly.balmes53636

That's it! It was a text column - thank you so much! 

kelly.balmes53636

It does work now but it's counting back calendar days and not work days - any ideas??

Paul Newcome

Hmm... I'm not sure. I just tested it again, and it was counting "workdays" (Monday - Friday). Putting in a start date of 6/29 gives me a result of 5/18.