Excel Date Problem

B

brett4098

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

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)
 
B

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)
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top