NETWORKDAY and WORKDAY formulas

[broncos347]

I have a spreadsheet that tracks consent approvals where we have a KPI for a 28-day response time, and I want to calculate the actual response time, I have a formula in the cell already that calculates part of what I want to do however I am getting stuck on the remainder. I want to work the network days out between two dates if column L is populated with a date or column L is blank and column M has the word "OVERDUE" in the cell. Also, if column L is blank and column M has the word "OVERDUE" I would like to calculate the workdays between the issue date and today's date. Hopefully, this all makes sense. Any help would be appreciated.

++Greater Anglia Approvals Log.xlsm
	D	E	F	G	H		J	K	L	M	N
3	Tenant Name (free text)	LLC Description (free text)	Linked LLC (free text)	GA Single Point of Contact	Date LLC Issued to GA		Anticipated Response by	Target Response KPI	Actual Date of Response	Response Status	Actual Response Time
4	ANO Coffee & Tea	Coffee Shop and Restaurant		AB	02/01/2024		09/02/2024	28		Resubmit
LLC Log NEW

Cell Formulas
Range	Formula
G4	G4	=VLOOKUP(C4,'Location Data'!B:U,20,FALSE)
J4	J4	=WORKDAY(H4,$K$2)
K4	K4	=$K$2
M4	M4	=IF(ISBLANK(H4),"",DOCSTATUS(H4,O4))
N4	N4	=IF(L4="","",NETWORKDAYS(H4,L4)-1)

Cells with Data Validation
Cell	Allow	Criteria
G3	List	=Engineers

 

[Dave Patton]

You may secure help if you post examples with complete information and expected results.
What formula did you try?
N.B. Your post includes links to information; consequently, all the information doesn't show.

 

[Dave Patton]

No response to post # 2.
Guess

Workday.xlsm
	D	E	F	G	H	I	J	K	L	M	N
1					info
2
3	Tenant Name (free text)	LLC Description (free text)	Linked LLC (free text)	GA Single Point of Contact	Date LLC Issued to GA		Anticipated Response by	Target Response KPI	Actual Date of Response	Response Status	Actual Response Time
4	ANO Coffee & Tea	Coffee Shop and Restaurant			02-Jan-24		09-Feb-24	28	10-02-24	overdue	29
5					02-Jan-24		02-Feb-24	24		Overdue	27
1b

Cell Formulas
Range	Formula
M4	M4	=IF(NETWORKDAYS(H4,L4)>K4,"overdue","")
K5	K5	=NETWORKDAYS(H5,J5)
N4:N5	N4	=IF(M4="overdue",NETWORKDAYS(H4,IF(L4="",TODAY(),L4)))