Please help I have been staring at the same screen for an hour and can't work something out!
Previously I have been able to drag down a NETWORKDAY calculation but for some reason today it doesn't want to work.
I have a dates in column J and todays date in column K all I need to work out is the net working days between the 2. I have created this =NETWORKDAYS(J2,K2) which has worked for the first row but now I just want to drag it down and it do it for the rest of the rows!!!!!!
HELP BEFORE I GO MAD OR GET FIRED FOR BEING LATE WITH MY REPORT!!!!!!
Previously I have been able to drag down a NETWORKDAY calculation but for some reason today it doesn't want to work.
I have a dates in column J and todays date in column K all I need to work out is the net working days between the 2. I have created this =NETWORKDAYS(J2,K2) which has worked for the first row but now I just want to drag it down and it do it for the rest of the rows!!!!!!
HELP BEFORE I GO MAD OR GET FIRED FOR BEING LATE WITH MY REPORT!!!!!!