Hi,
I am trying to find out the deficit between target and achieved each day. I am doing this by subtracting the achieved amount from the target amount and then adding the deficit the following day and replicating the process once again. However I have come across a little difficulty as I cant do this without including a Saturday and Sunday can anyone help me with this? I have attached a workbook with the column highlighted.
Thanks
Johnny
Can you explain exactly what the column should do? You said you didnt want Saturdays or Sundays included but there are rows of data in the sheet for Saturdays?
If its just that you dont want to run the BA10-BG10 calc if its a weekend then this should do it
(you may want to change the FALSE outcome to something other than zero)
=IF(NETWORKDAYS(A10,A10)>0,BA10-BG10,0)
If someone has helped you then please add to their Reputation
Tracker.xlsm Here. I used the "weekday" function to create a boolean function returning "true" if the date passed as argument is a weekday.
Sorry for not being clear, I need the expression to skip Saturdays and Sundays in column BB so that it does not add the amount the previous deficit amount onto the total making the data inaccurate.
Isn't that the case in the file I posted? When I look at it, cell BB16 is Friday and the two cells beneath it, Saturday and Sunday, stay at the same value, and the next calculation occurs at Monday's line.
ggs22, Thats is correct working perfectly now, many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks