Excel Date Problem

  • Thread starter Thread starter brett4098
  • Start date Start date
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
 
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)
 
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)
 
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.
 
Back
Top