Advanced use of WORKDAY function

S

sue

I am using the WORKDAY function successfully to calculate 3 days from a given
date but I would now like to extend this & perform a check whether to use 3
or 5 days depending on an input of small or lagre. Is this possible ?

s=3 days
l=5 days

=WORKDAY(date,s or l)
 
J

Jacob Skaria

Do you mean?

A1 = Date
B1 = s or l

=WORKDAY(A1,IF(B1="s",3,5))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top