Trying to Calculate SLA on Network days

Please explain what the formula is meant to do (the calculation).

=IF(ISBLANK(I3),NETWORKDAYS(H3,J3,'Network Days'!A2:A14),NETWORKDAYS(H3,I3,'Network Days'!A2:A14))

There is no date in either H3 or J3 - NETWORKDAYS needs a start and end date.

I have no idea what SLA is.

It's because I copied it from another worksheet but left out some identifying cells (nothing relevant to the calculation) so the dates are in e, f, g, sorry for the confusion

I modified it to reflect the correct cells
=IF(ISBLANK(F3),NETWORKDAYS('Network Days'!A2:A14, E3,G3),NETWORKDAYS('Network Days'!A2:A14, E3,H3))

The dates in your workbook are not presenting as dates here - they are just text. Change their columns to GENERAL formatting, and if they change to a 5-digit serial number with decimal places, then they are dates. If not, like here, they are just text. You need to fill those columns with real dates.

AliGW on MS365 Insider (Windows) 64 bit

	E	F
1	Date/Time Logged
2	44564.32132	Real Date
3	2022-01-03 14:27:12	Text
4	2022-01-03 15:23:54

Sheet: Sheet1

I still don't know what your formula is MEANT to be doing or what SLA is.

Not sure what to say, the dates are exported from our ITSM software as dates with year-mm-dd hh:mm:ss format, I have formated the cells to general

The formula is trying to calulate the time between date/time logged & date resolved (or today's date, if date resolved is blank)
SLA is service level agreement.

We have a vendor that is contractually obligated to fulfill requests within a 2 day "SLA" and I'm trying to calculate if they are meeting that on a monthly basis.

I have to take all the requests, calculate the time to resolution and see if the average is above or below 2 days.

Yes, as I feared - they are text, not dates, so NETWORKDAYS cannot use them.

Your first job before you can go any further is find a way to import the data with dates and times intact. If that's not possible, then we'll need to look at different options.

At the moment, your formula is not the issue per se.

I’m on my phone so can’t look now. If nobody else chips in overnight, I’ll have a look in the morning.

Yes - just gone! Going offline now. 😊

Originally Posted by H1ghway

I've added the raw data attachment, I've done nothing with it from my export.

Select column C. Go to Data | Text to Columns. Press Next twice, then select Date DMY and Finish. You should now have proper date time values to work with.

Let me know how you get on.

So, how are we doing? Did any of this help?