Hello,
I am having issues trying to hide a calculated date using the WORKDAY function when a cell is blank. I am using =WORKDAY(G2,45) I am calculating 45 days from the initial start date for each project. G = start date of the project, M = closure date (45 days from G). When pasting the function down column M I get a date of 3/2/1900 when the data is G column is blank. Is there any way to hide this date when using the WORKDAY function?
Thank you
Chad
Bookmarks