Hi,
I would like the enclosed =IF formula editing to change the text message as shown in the example.
Many thansk for any help with this
Hi,
I would like the enclosed =IF formula editing to change the text message as shown in the example.
Many thansk for any help with this
Last edited by junada0; 05-11-2010 at 10:04 AM.
Here, try this:
=IF(B2="","date missing",IF(B2-A2<0,"date in the past",NETWORKDAYS(A2,B2)))
Many thanks for your help, easy when you see your answer.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks