My spreadsheet has columns for 2 dates (date requested, date issued) and I have another column that counts the number of days in between. Right now, the formula is =NETWORKDAYS(A254,E254)-1
My problem is if the date of issue column is blank, it displays a large negative number.
What I'd like to do is, if the issue column is blank, have it display the number of days from the date of request to the current date.
Thank you
Bookmarks