Formulas to Fill Range with Date

[Gos-C]

Hi all,

Can you please take a look at the attached file and tell me how to fix the errors in B31 and B32 in worksheets Text in Upper Case and Text in Upper Case (2).

Thank you,
Gos-C

[shg]

B31 is referring to blank cell B30 and trying to interpret as a date.

If you bring up the formula auditing toolbar, you can watch the formula evaluate step by step.

[Gos-C]

Hi Shg,
Thanks for your help.

I modified the formulas in B31 and B32 as follows:

B31

=IF(B28+3>$A$1,"",IF(B29+2>$A$1,"",IF(B30="","",IF(B30+1>DATE(YEAR($A$1),MONTH($A$1)+1,0),"",IF(B30+1>$A$1,"",B30+1)))))

B32

=IF(B29+3>$A$1,"",IF(B30="","",IF(B30+2>$A$1,"",IF(B31="","",IF(B31+1>DATE(YEAR($A$1),MONTH($A$1)+1,0),"",IF(B31+1>$A$1,"",B31+1))))))

Error is gone!

Gos-C

[shg]

Seems very complicated. What's the purpose?

[Gos-C]

It is for a spreadsheet used to log daily report totals.

Gos-C