Hi, how can I edit my formula to show blank after the travel date ends?
Currently dates are running based on start of travel date +1.
However it will show up an error # after the last date.
Your guidance is much appreciated.
Hi, how can I edit my formula to show blank after the travel date ends?
Currently dates are running based on start of travel date +1.
However it will show up an error # after the last date.
Your guidance is much appreciated.
Add an extra clause to your IF statement, e.g. in cell K3:
=IF(J$3="","",IF(J$3+1<=$P$1,J$3+1,""))
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks