| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sales Schedule
c1 Date Sold
d1 Date Acquired e1 Proceeds f1 Cost Basis To determine if the capital gain/loss is short-term, I can use this formula: IF(C1-D1<=365,C1-D1,0); however that won't work for a leap year. A short-term gain/loss is one year or less. What forumula would I use? Thanks, -- Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating sales commission that changes based on a sales volume | Excel Worksheet Functions | |||
| Sales Invoicing linked to Sales ledger(Accounts Receivable) | Excel Discussion (Misc queries) | |||
| Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
| sales needed to cover costs that increase as sales do | Excel Worksheet Functions | |||
Threaded Mode
