HOW TO ADD DATE COUNTER?

[JESSICA BDI]

Hi there. First off, I am a complete newbie when it comes to Excel. At work I have set up a worksheet to keep track of our projects. My boss would like to have some sort of ongoing counter in the sheet that will count from the day an order comes into our office to the day we ship the order out. Is this possible? If so, how do I do it? Thanks for the help!

 

[Smitty]

Welcome to the Board!

Here's an example that might help:

Book3
	A	B	C	D
1	Order In	Ship Date	# Days
2	1/1/2006	4/6/2006	95
Sheet2

It assumes a "hard" date for the order in/out, then just subtract one from the other to get the number of days between.

Hope that helps,

Smitty

 

[JESSICA BDI]

STILL HAVING A PROBLEM

Ok, when I type in that formula it enters a date, not a number as the result. ??? Also, I have 200 projects, can I calculate the days for all of them at once? And, is there a way that the counter can be on going and change by itself as the days go by, or do I every day have to recalculate? Thanks so much for your help, I know some of this is probably completely obviously to you

 

[LxQ]

Click on the cell, or better yet, select the whole column, click on Format, Cells, and select either General or Number format on the Number tab.

Not sure what you mean by ongoing, but I would assume the Order In date is set.. and possibly you want to keep counting the days until it is finally shipped out, then stop counting..

use this formula: =IF(B1<>0,+B1-A1,TODAY()-A1)