VBA datestamp for an array

[isometric]

Hi all,

I need help. My knowledge in VBA is basically non-existent.

I have an array in B$4:B$20 (i will put the same array on different columns) and would like a static datestamp (dd/mm/yyyy) in C$4:C$20 (i will also copy this as I copy B4:B20 on different columns) when B$4:B$20 is filled. I would also like C$4:C$20 to be blank if B$4:B$20 is blank.

The array in B$4:B$20 is an IFERROR formula that will return names if true and "" if false.

Many thanks to anyone willing to help

 

[isometric]

solved by enabling iterative calculation.