today's date leave blank

[VbaHell]

Hello all

Can I have some help please on this

I want to include in the formula below

[IF TODAY() > TODAY () Leave blank

[Range("C23:P34").FormulaR1C1 = "=SUMIFS(Sales!C9,Sales!C5,R21C,Sales!C16,R22C,Sales!C21,R4C3,Sales!C24,RC2)"

Is this possible please

 

[MUKESHY12390]

it looks like you are looking for VBA solution, are you?

 

[VbaHell]

Yes please

 

[MUKESHY12390]

this statement doesn't make any sense "TODAY() > TODAY ()". I mean that's not possible I took "Sales!$A$1" to store a value you can change it to any range.

=IF(Sales!$A$1>TODAY(),"""",SUMIFS(Sales!$I:$I,Sales!$E:$E,C$21,Sales!$P:$P,C$22,Sales!$U:$U,$C$4,Sales!$X:$X,$B23))

 

[VbaHell]

ok, no you are right, sorry