Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workdays
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workdays
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workdays issue | Excel Discussion (Misc queries) | |||
Net Workdays | Excel Discussion (Misc queries) | |||
Workdays | Excel Worksheet Functions | |||
Workdays Function | Excel Worksheet Functions | |||
Workdays | Excel Discussion (Misc queries) |