This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How can I get my formula to only show WORKDAYS with the IF function I am currently using? My formula currently works but it calculates all days, and I need it calculate just work days.
Column B is the Due Date for assets
Column C is the date the assets were actually posted
Column D is the formula =IF(C2=B2,"On Time",IF(C2<B2,"Ahead of Schedule",(C2-B2)&" Days Past Due"))
| Asset Due Date (Column B) | Asset Posted Date (Column C) | Assethub <br>Days Late (FORMULA) |
|---|---|---|
| 23-Feb | 20-Feb | Ahead of Schedule |
| 23-Feb | 20-Feb | Ahead of Schedule |
| 1-Mar | 4-Mar | 3 Days Past Due |
I tried using this formula =IF(WORKDAY(C2=B2,"On Time",IF(C2<B2,"Ahead of Schedule",(C2-B2)&" Days Past Due"))) but it says there is an error with my formula. I have tried NETWORKDAYS.INTL but it does not produce what I need (i.e. I don't want a number to be produced if something was delivered on the due date).
How can I get the formula to only show WORKDAYS with the IF function I am currently using?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
=IF(C2=B2,"On Time",IF(C2<B2,"Ahead of Schedule",NETWORKDAYS.INTL(B2,C2)&" Days Past Due"))