Workday Function

[Seph]

I need the following formulas to report only weekdays.

=IF(F2="","",IF(K2<"","Submitted",IF(F2>=TODAY(),EDATE(F2,0)-30,IF(F2<TODAY(),"Today",""))))

=IF(F2="","",IF(G2="S",EDATE(F2,-2),IF(G2="R",EDATE(F2,-2),IF(G2="A","Not Needed",IF(H2="A","Bed Date Attained",IF(H2="S","Submitted",IF(H2="",EDATE(F2,-2),"")))))))

Here is the actual spreadsheet:

The first formula is in J2 and the latter is in I2

https://docs.google.com/spreadsheets/d/1oLYbI0sx8qUZ4pHJXMxI2CC9ZD45p03ybZUFsng2BmQ/edit?usp=sharing

 

[skywriter]

For the formula in I2 you can try this, it pushes the date to the following Monday if it is a Saturday or Sunday. Your formula for J2 makes no sense to me. IF(K2<"", doesn't make sense, you are asking if K2 is less than empty? If you could explain that I could look at it further, but if you see what I did in the other formula maybe you can figure it out for yourself. I know the formula is long and there may be a better way, but this is what I came up with and it appears to work.


Sheet1

*	A	B	C	D	E	F	G	H	I

<tbody>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="bgcolor: #ccccff, align: left"]Joe[/TD]
[TD="bgcolor: #ccccff, align: left"]KF2726[/TD]
[TD="bgcolor: #ccccff"]*[/TD]
[TD="bgcolor: #ccccff"]*[/TD]
[TD="bgcolor: #ccccff, align: left"]7/27/2014[/TD]
[TD="bgcolor: #ccccff, align: center"]7/24/2014[/TD]
[TD="bgcolor: #ccccff, align: center"]S[/TD]
[TD="bgcolor: #ccccff"]*[/TD]
[TD="bgcolor: #ccccff, align: center"]5/26/2014[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula I2 =IF(F2="","",IF(G2="S",IF(WEEKDAY(EDATE(F2,-2))=1,EDATE(F2,-2)+1,IF(WEEKDAY(EDATE(F2,-2))=7,EDATE(F2,-2)+2,EDATE(F2,-2))),IF(G2="R",IF(WEEKDAY(EDATE(F2,-2))=1,EDATE(F2,-2)+1,IF(WEEKDAY(EDATE(F2,-2))=7,EDATE(F2,-2)+2,EDATE(F2,-2))),IF(G2="A","Not Needed",IF(H2="A","Bed Date Attained",IF(H2="S","Submitted",IF(H2="",IF(WEEKDAY(EDATE(F2,-2))=1,EDATE(F2,-2)+1,IF(WEEKDAY(EDATE(F2,-2))=7,EDATE(F2,-2)+2,EDATE(F2,-2))),""))))))) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4