Help needed with IF & WORKDAY function

[beebecky1]

Hi
I am fairly new to excel and only really know the basics so would really appreciate some help.


In A column the date something is received will be entered.
In B column there is a drop down list that has "insured" "Fee" "Aged Debt" "Other".
In C column I am trying to get another date to populate dependant on what is picked from column B, so if Insured is picked then 1 working day needs to be added to the date in column A and populate in column C. If any of the other 3 options are selected 5 working days needs to be added to the date in column A and populated in column C.

I have been using this formula: =IF(B2="","",IF(B2="Insured",A2+1,A2+5)) however this is not working days and I am stuck how to get to add working days!

Thanks
Becky

[Fotis1991]

Please Login or Register  to view this content.

[beebecky1]

Please Login or Register  to view this content.

Thanks Fotis for such a quick reply. I have just tried this formula but it comes back with an error saying that the formula needs a parenthesis? Being a newbie I am not really sure what this means??
Thanks Becky

[Fotis1991]

Try

Please Login or Register  to view this content.

It means that need 1 more parenthesis at the end of the formula.

Also: Welcome to the forum!

[beebecky1]

Awesome thanks so much, it has worked