Workdays
Perfect. Thanks!
--
collshops
"Mike H" wrote:
Hi,
I assume DATE A is a named range, if so it's invalid because spaces aren't
allowed in named ranges so try this
=IF(ISNUMBER(Date_A),WORKDAY(Date_A,7),"-")
or if you really mean a cell reference try this
=IF(ISNUMBER(A2),WORKDAY(A2,7),"-")
Workday can have an optional parameter of holidays
=IF(ISNUMBER(A2),WORKDAY(A2,7,Holidays),"-")
Where Holidays is a named range of holiday dates.
Mike
"collshops" wrote:
I need an "IF" formula. If there is a date in the cell "Date A" I need a
formula to calculate Date A plus 7 workdays. If there is no date in Date A,
I want that formula to simply show a blank space or maybe a dash "-".
How do I know if my add-ins are installed?
--
collshops
|