Advanced use of WORKDAY function
 

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)

Advanced use of WORKDAY function
 

Are you wanting something like:

=if(A2="S",WORKDAY(date,3),WORKDAY(date,5))

"sue" wrote:

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)

Advanced use of WORKDAY function
 

Do you mean?

A1 = Date
B1 = s or l

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

If this post helps click Yes
---------------
Jacob Skaria


"sue" wrote:

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)

Advanced use of WORKDAY function
 

Thanks thats brilliant.

"Jacob Skaria" wrote:

Do you mean?

A1 = Date
B1 = s or l

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

If this post helps click Yes
---------------
Jacob Skaria


"sue" wrote:

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)

Advanced use of WORKDAY function
 

Thanks very much for the quick response - working well.

"Sean Timmons" wrote:

Are you wanting something like:

=if(A2="S",WORKDAY(date,3),WORKDAY(date,5))

"sue" wrote:

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)