Hi Gang, I'm a neophyte that has become fascinated with Excel. The possibilities seem endless, but my knowledge certainly isn't.
My current project is a spreadsheet that can calculate interest on inventory by taking interest rate and days in stock and returning dollar amounts. I think I can figure out the rate calculation (time will tell), but currently am befuddled by number of days in stock formula. Receiving date of incoming inventory entered in column A, and column B would indicate days in stock based on current date. My intuition tells me it's possible, but after perusing help menus for a couple of hours,I'm lost.
Any help would be greatly appreciated.
Shalom, PJ
My current project is a spreadsheet that can calculate interest on inventory by taking interest rate and days in stock and returning dollar amounts. I think I can figure out the rate calculation (time will tell), but currently am befuddled by number of days in stock formula. Receiving date of incoming inventory entered in column A, and column B would indicate days in stock based on current date. My intuition tells me it's possible, but after perusing help menus for a couple of hours,I'm lost.
Any help would be greatly appreciated.
Shalom, PJ