Excel Tips Archive

Inventory Freight Calculation

To account for freight on incoming inventory, I allocate the freight charges proportionately over the inventory items by total value. Quickbooks doesn’t have a way to handle that, so I use a simple Excel spreadsheet to do the calculation. The last entry is always the freight (or handling or whatever I want to distribute).

Continue Reading

Entering dates quickly, without having to use delimiters to separate month, day, and year.

nter only the “day” part of the date and complete it by using the DATE, YEAR, TODAY, and MONTH functions in the following formula: =DATE(YEAR(TODAY()),MONTH(TODAY()),A2) Thus, on entering “5”, the formula will automatically create a date representing the 5th of the current month in the current year. Solution 2: Enter the entire date, without

Continue Reading