Forum Discussion

drt_80's avatar
drt_80
Copper Contributor
May 17, 2019

Blank workbook when first opened until key dates are entered.

Hello, In the attached workbook, I would like the three colored tables to be blank when opening until a couple of dates are entered. Once Cell B6 is a manually entered, Cell A19 = that date. Then t...
excel
Formulas and Functions
gs_aujla's avatar
gs_aujla
Copper Contributor
May 17, 2019

drt_80 Maybe I am not understanding your problem properly but why can't you use and IF statement in the cells that you want blank until date is entered in B6 & B7?

drt_80's avatar
drt_80
Copper Contributor
May 20, 2019

I am creating this for other people to use. I am wanting it to be as simple as possible for them to use. The only cells I want them in is A1:B12 and columns J,K,& L. I am fairly new to excel, therefore i am not sure of the correct formulas to use to achieve what i am wanting. Thanks. gs_aujla