Workdays

  • Thread starter Thread starter collshops
  • Start date Start date
C

collshops

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?
 
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
 
Perfect. Thanks!
--
collshops


Mike H said:
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
Click to expand...
 
Back
Top