April 2018

I am trying to make a formula to determine how many days (minus weekends) it took to complet a project. The problem is that I have one employee Alan Bown (initials AB) who works Monday-Friday and a second employee Cristopher Duncan (initials are CD) who work Monday-Thursday. I know that the formula for "AB" would be:

**SUM(INT((WEEKDAY(B1-{2,3,4,5,6})+C1-B1)/7))**

and the formula for "CD" would be:

**SUM(INT((WEEKDAY(B1-{2,3,4,5})+C1-B1)/7))**

If the employee's initials are in cell A1, project start date is in cell B1 and project end date is in cell C1, I want to create a formula that says "if A1 = AB then use this formula, but if A1 = CD then use the other formula"

Try this

=IF(A1="AS",$B$1,IF(A1="BS",$B$2,IF(A1="GS",$B$3,IF(A1="HG",$B$4))))

- Replace the "AS","BS","GS", "HG" with the initials of the employees.
- Replace the $B$1, $B$2, $B$3, $B$4 with the formulas.

The IF formula is

Thanks to ExcelJosh for this tip.

- Excel - A formula to separate data
- How to copy data from one sheet to another in excel using formula » How-To - Excel
- Excel moving data from one cell to another » Forum - Excel
- Formula to copy data from one cell [Solved] » Forum - Office software
- Excel - Link data from one cell to another » How-To - Excel
- Excel - VBA code for deleting data in row while keeping formulas » How-To - Excel