Australian Financial Year

Try this for the first part
=IF(MONTH(A1)<7,DATE(YEAR(A1),6,30)-A1,DATE(YEAR(A1)+1,6,30)-A1)

not sure what you're asking in the second question.

Originally Posted by Crooza

Try this for the first part
=IF(MONTH(A1)<7,DATE(YEAR(A1),6,30)-A1,DATE(YEAR(A1)+1,6,30)-A1)

not sure what you're asking in the second question.

That formula works well, thanks Crooza.

I guess what I mean by the second question, is that I need to put a formula (in any cell) that will display the f/y end date:

1. With the “30 June” constant.
2. And replace the yyyy variable with the appropriate year, by getting its cue from A1.

I know I can do it manually, but I want to minimise the keystrokes, and remove the potential for making mistakes.

Thanks,
mgs

Originally Posted by daddylonglegs

For days elapsed in current financial year you can use this version

=A1-DATE(YEAR(A1+184)-1,6,30)

for days remaining (not including A1) use this

=DATE(YEAR(A1+184),6,30)-A1

and for end date of the year you can use this version

=DATE(YEAR(A1+184),6,30)

Thanks daddylonglegs, that's exactly what I wanted.

Cheers,
mgs