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

 
JohnMac328Asked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
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

=B2-A2

format C2 as general - does that work for you?

regards, barry
0
 
nutschCommented:
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
0
 
Limey1212Commented:
Have you tried the DATEDIF function in Excel?

Here is a link that should help you:

http://www.cpearson.com/excel/datedif.aspx
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
JohnMac328Author Commented:
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
0
 
Limey1212Commented:
Just to be clear, cell A1 has this:

20110303 – 20100303

as it's contents?
0
 
JohnMac328Author Commented:
Having trouble getting away from meetings - will respond as soon as possible
0
 
JohnMac328Author Commented:
That works - thanks.
0
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.

All Courses

From novice to tech pro — start learning today.