date calculation

hello everyone,

i have finally managed to create the perfect inventory manager with just one setback which is the using date to identify how many days have passed
i'v uploaded the excel workbook for calculation if someone wants to see it, its in sheet2 which is named "daily use"


i have the following formula in E5

HTML Code: 

, it will always show the today date and will update itself everyday.

and everytime i request an item im writing down the order date by just simply typing the date or hitting the control ; button.

now i know if i deduct the normal hand written date ( which stays the same ) out of the =today() date ( which updates itself everyday ), the next day the answer should be 1, but in a table its not that simple its giving a whole bunch other numbers and dates, can it be turned into one digit ?

This is a duplicate post.

http://www.excelforum.com/excel-prog...lculation.html

the formula "=today()" is in sheet2 which is named "daily use" in cell E5, and in column G im trying to deduct column E out of E5, so in column G i can have the number of the days which have passed the next and the day after, as the days pass E5 will change and show the current day and column E dates wont change therefore i will have column G numbers adding up everyday by 1