On-Time calculations - using only workdays?

AndySc

New Member
Joined
Apr 1, 2019
Messages
2
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

Well-known Member
Joined
Oct 24, 2012
Messages
3,425
=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

New Member
Joined
Apr 1, 2019
Messages
2
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

Well-known Member
Joined
Oct 24, 2012
Messages
3,425
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.


 
Last edited:

Forum statistics

Threads
1,085,014
Messages
5,381,232
Members
401,721
Latest member
karloqs

Some videos you may like

This Week's Hot Topics

Top