Finacial year - automatic formula change

[DaveR]

Hopefully this should be simple.....

What I am attempting to achieve is to have my financial year change cell update automatically, so I don't have to bother every year changing the cell from 1-Apr-2011 to 1-Apr-2012.

All ideas greatfully accepted.

 

[ukmikeb]

Hi

Try -

=DATE(IF(TODAY()>DATE(YEAR(TODAY()),3,31),YEAR(TODAY()),YEAR(TODAY())-1),4,1)

hth

 

[DaveR]

Thank you!

 

[Misca]

Try something like:

=DATE(IF(TODAY()<DATE(YEAR(TODAY()),4,1),YEAR(TODAY())-1,YEAR(TODAY())),4,1)

Instead of having that in a cell you might want to use that as a name in your workbook.