Excel Date Problem

[brett4098]

WHY DOESN'T THIS FORMULA WORK? (=DAYS360(TODAY(),F22))
I TRYING TO CALCULATE THE DAYS BETWEEN A CERTAIN DAY AND THE CURREN
DATE

 

[Bob Phillips]

Brett,

This works

=DAYS360(TODAY(),F22)

did you really pout brackets around the whole formula?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[brett4098]

no, i had not. Thanks for your inpu

 

[Bob Phillips]

Brett,

I thought that might be the case.

So do you still have a problem?
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Norman Harker]

Hi Brett!

Please don't use all upper case. It's considered on newsgroups to be
shouting, which is rude. It's also much more difficult to read
especially if your first language is not the one used.

But are you aware that DAYS360 uses a special algorithm of
calculation. The DAYS360 tends only to be used in limited accounting
situations.

Where:
A1: 18-Dec-2003
=DAYS360(A1,TODAY())
Returns: 19

But
=TODAY()-A1
Returns: 20

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.