Hello
I need the cell to show blank when there is no Entry in E3.
Thank youPlease Login or Register to view this content.
Hello
I need the cell to show blank when there is no Entry in E3.
Thank youPlease Login or Register to view this content.
You can do this:
=IF(E3="","",WORKDAY(E3+5-1,1,Sheet2!$A:$A) )
Hope this helps.
Pete
Really? After 10 years on the forum? You must have done this sort of thing before.I need the cell to show blank when there is no Entry in E3.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you so much. Got it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks