Preamble:
A Financial Year, is from 1 July through to 30 June, inclusive.
The formula (which was offered by this forum, and appears below), is
required to display (countdown) the day(s) remaining in a Financial
Year, on a cyclical basis.
The formula worked well, towards the end of the last Financial Year,
but...


The problem:
Since the beginning (1 July) of this Financial Year, the countdown
display is preceded by a minus (-) character. I know it's trivial, but
it's also irritating...
How do I, remove the minus character?


The Formula:
=DATE(YEAR(TODAY())-IF(MONTH(TODAY())<7,0,1),7,1)-TODAY()

Regards,
Mick.


--
mick2
------------------------------------------------------------------------
mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=384021