Hello, having some problems with the NETWORKDAYS formula. On my spreadsheet I received the dates at different intervals. I don't want the formula to calculate using only one date. So I want the 'Days Between' column I have to remain blank until I have both dates in the spreadsheet. Right now I am trying:
=IF(P2="",[""],[NETWORKDAYS(N2,P2)])
where N2 has a date, P2 has no date and the formula is in cell O2.
Any help would be greatly appreciated. Thanks!!!
Perhaps =IF(or(n2="",P2=""),"",NETWORKDAYS(N2,P2))
That worked!!!!
Thanks!!!
If I may ask, why did you add the square brackets in your formula?
good question
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks