The Australian financial year is 1 July-30 June, inclusive.
Random starting dates (dd/mm/yyyy) are entered in A1 and the following formula returns the number of days already used in the f/Y.
=IF(MONTH(A1)<7,A1-DATE(YEAR(A1)-1,6,30),A1-DATE(YEAR(A1),6,30))
1. What formula returns the number of unused days (leap year inclusive)?
2. What formula returns the finishing date (30 June yyyy)?
mgs
Bookmarks