Making An Array Formula Work

[toplad]

Hi,

For years I've been dragging and dropping formulas when i should of being using an array formula. However i'm stuck trying to make this a working array formula:


=ARRAYFORMULA(IF(ISBLANK(A2),"",IF(G2<TODAY(),"passed date",IF(G2<TODAY()+30,"Due In 30 Days","current"))))



I'd also like to make it print the heading although just getting the code working at the moment is a priority!


Thanks in advance for any help or advice that is given

 

[RoryA]

Is this a Google sheets question rather than Excel?

 

[toplad]

Yes it is, I was looking at using both excel and sheets for the task as we have both versions at different locations

 

[RoryA]

OK, I've moved the thread to the appropriate location then.

What makes you think this needs to be an array formula?