Minus Display

[mick2]

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.

 

[Sandy Mann]

If all you want is to always have a positive number then wrap the formula in
an ABS function:

=ABS(DATE(YEAR(TODAY())-IF(MONTH(TODAY())<7,0,1),7,1)-TODAY())


--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Bob Phillips]

=ABS(DATE(YEAR(TODAY())-IF(MONTH(TODAY())<7,0,1),7,1)-TODAY())

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[loudfish]

Mick

It's a simple error in the formula. Flip the sign and it will work:
=DATE(YEAR(TODAY())+IF(MONTH(TODAY())<7,0,1),7,1)-TODAY()

I think you're simpler storing the financial year end in a cell (e.g.
A1), then you can use:
=A1-TODAY()

.... as long as you update A1 once a year.

Best

Andrew

 

[mick2]

Thanks folks,
Problem solved!

Regards,
Mick.