On-Time calculations - using only workdays?

[AndySc]

All, I need to calculate whether a production item is On-Time (early or on-time), or Late, using workdays only to calc. I also want to be able to get a summary or total by month or similar. I have the following set up already:
Deadline Date
Actual Production Date
If Actual is earlier or same as Deadline, then Y. If later, then N.

 

[etaf]

=if( Deadline date cell > = actual production date , "Y" , "N" )

not sure about getting a summary , as dont know how the data is structured and also not sure exactly what you want

But you could I assume count the "Y" by month using perhaps a =COUNTIFS()

 

[AndySc]

etaf,

Thanks for the reply. I have two scenarios that remain issues. If I put SR(text shorthand for Stock Replenish) into Deadline Date cell, it shows as Y even before I load an Actual Date. Also, if I leave the Actual Date cell blank, it also shows Y.
Any way around he issues?

Andy

 

[etaf]

why are you putting text into a date cell?

the blank actual date is seen as zero
so we could add
AND ( actual production date < > "" , Deadline date cell > = actual production date )

=if( AND ( actual production date < > "" , Deadline date cell > = actual production date ) , "Y" , "N" )

now there has to be a value in actual production date

can you explain further

if I put SR(text shorthand for Stock Replenish) into Deadline Date cell, it shows as Y even before I load an Actual Date.