Hi,
I have written a custom function for calculating Uptime of Printers.
[VBA]
Function UpTime(StartDate, EndDate, NoOfMcs, DownTime)
UpTime = (Networkdays(StartDate, EndDate) * 8.5) * NoOfMcs - DownTime / (Networkdays(StartDate, EndDate) * 8.5)
UpTime = Application.Round(UpTime, 2)
End Function
[/VBA]
Here iam getting an error "Sub or Function not defined" and the Networkdays is higlighted with Yellow Color
Can anybody help me to sort out this Error.
I have attached a sample workbook herewith.
Thanks in advance