• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 837
  • Last Modified:

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

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


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.

Have you tried the DATEDIF function in Excel?

Here is a link that should help you:

JohnMac328Author Commented:
First cell is this,

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

Each Cell In This Column has that FORMULA.



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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Just to be clear, cell A1 has this:

20110303 – 20100303

as it's contents?
barry houdiniCommented:
As Thomas says, if these are valid dates then you can just subtract, so if 20110303 is in A2 and 20100303 is in B2 use this formula in c2


format C2 as general - does that work for you?

regards, barry
JohnMac328Author Commented:
Having trouble getting away from meetings - will respond as soon as possible
JohnMac328Author Commented:
That works - thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now