Hi all,

I have a cell that I put a date into.
I then make that cell a named range "end_date".

The formula I am using is =year(end_date).

If I use VBA to calculate the cell it won't update.

The only way I can get it to update is click on the cell and press enter.

Any ideas?

Thanks