Solved need to formula to automate date +5 days

October 7, 2015 at 13:32:22
Specs: Windows 7
Re: Excel formula

1. B2 contains date 10/1/2015
2. B3 needs to contain B2 + 5 WORKDAYS 10/07/2015

When I use the WORKDAY function, it calculates correctly However, I want B3 to stay blank if B2 is blank.

right now it displays this when B2 is blank: 1/5/1900

Can anyone help me with this, pretty please?

message edited by lizzyb1120

See More: need to formula to automate date +5 days

Report •

October 7, 2015 at 14:18:46
✔ Best Answer
=IF(B2 = "", "", your current formula goes here)

Caveat: I'm assuming that by "if B2 is blank" you mean an empty cell.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •
Related Solutions

Ask Question