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, it will always show the today date and will update itself everyday.HTML Code:
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 simpleits giving a whole bunch other numbers and dates, can it be turned into one digit ?
Bookmarks