Hi all
I am trying to increase this function into column/cell 'I2' :-
=WORKDAY(Tracker!$H2,2,Stuff!$A$2:$A$12)
I want to count 2 working days (excluding UK bank holidays which I have listed in 'Stuff!'. However if no date has been entered into H2, then I want it to be blank in I2. I have been trying the IF function " " but I cant get it to work. Can anyone suggest how I can perform this action?
Thanks
Tina
=if(H2="","",WORKDAY(Tracker!$H2,2,Stuff!$A$2:$A$12)) ought to do it...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn
You are a superstar!
Thank you so much.
Tina
Aww shucks! You say the nicest things
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks