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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date Formula 0
Conditional formatting referencing multiple cells. 3
Multiple functions, conditional functions 7
Calculating days spent to complete a task 2
Conditional Formatting - Cannot get it to work, please help 1
Formula I can't figure out 2
Display weeks from a Milestone 0
Another Formula 3

Top