Hi,
Im using the below formula which will calculate the working days between 2 days and if Date 2 is blank then it will return a blank cell.
=IF(COUNT(Date1,Date2)<2,"",NETWORKDAYS(Date1,Date2,'Bank Holidays List')-1)
However, what I need to do is if Date2 is blank, then I need it to calculate based on TODAY()
Any help appreciated.
Nath'
Something like that?
=IF(ISBLANK(Date1), "", NETWORKDAYS(Date1, IF(ISBLANK(Date2), TODAY(), Date2), 'Bank Holidays List') -1)
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Perfect!
Thank you so much!
Glad I could help! Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks