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)
|