asked on

Excel - Date calculation for overdue reports

I am trying to do a date minus date to get overdue reports in excel.

If I use =date, I have to enter the date each day to calculate.

If I use =today() the answer is off the wall.

How can I get excel to calculate (yyyy,mm,dd) minus today’s date = days overdue?

Any help is appreciated

nutsch

how's your starting date formatted? You should be able to do

=today-a1()

and get a number of days if A1 is a valid date.

If A1 is something else than a valid date, can you tell us what it is, or load a sample file without confidential info.

Thomas

Limey1212

Have you tried the DATEDIF function in Excel?

Here is a link that should help you:

http://www.cpearson.com/excel/datedif.aspx

JohnMac328

ASKER

First cell is this,

The starting date is =DATE(YYYY,MM,DD)

Each Cell In This Column has that FORMULA.

NEXT COLUMN HAS THIS,

=TODAY()

This usually converts to the format assigned under format cell.

Problem is to get a total of days between the two dates, I can’t get the today to format like the =date. This give a weird answer.

I am trying to do this: calendar dateA1-calendar dateA12=number of days difference to show answer.

20110303 – 20100303 = 365.

Input auto answer

Limey1212

Just to be clear, cell A1 has this:

20110303 – 20100303

as it's contents?

ASKER CERTIFIED SOLUTION

barry houdini

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JohnMac328

ASKER

Having trouble getting away from meetings - will respond as soon as possible

JohnMac328

ASKER

That works - thanks.