CODEWITHSUNDEEP
google-sheets
McMahok
McMahok

Reputation: 360

ignore formula when using isblank

I have a google sheet which calculates dates based off other cells which are also dates. Using

=ARRAYFORMULA(IF(ISBLANK(K2:K1210),"",K2:K1210+12))

I can ensure that the cells remain blank if there is nothing in them, instead of getting the annoying 01/01/1900. However, when the cells which is "blank" contains a formula e.g. in this example there is a formula in the K column, which causes the cells with the array formula to display the "1900" date.

Is there a way to ignore formula so that the cells stay blank?

Upvotes: 0

Views: 4199

Answers (2)

Harun24hr
Harun24hr

Reputation: 36860

You can use below formula.

=ARRAYFORMULA(IF(LEN(K2:K1210)>1,K2:K1210+12,""))

Another formula can be-

=ArrayFormula(TEXT(K2:K,"m/d/e;;;"))

Upvotes: 1

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IF(K2:K1210="",,K2:K1210+12))

Upvotes: 0

Related Questions