| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date calculations resulting in negative numbers and averages
If you're just subtracting dates, then you should use:
=d3-c3 (and format the cell as General (not date).) Or =if(d3<c3,"",d3-c3) (still formatted as general.) Radrays wrote: Thank you for your time - I have a two fold question please. I am currently using =DAYS360(C3,D3) to calculate aging betwen dates. Is there a way to leave blank any cell with a value less than zero? Is there a formula I can use to take my calculated values from above and find the average aging? Thanks again, Radrays Using XP - Office 2007 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add days to a date and return resulting date | Excel Worksheet Functions | |||
| Negative numbers in resulting formula | Excel Worksheet Functions | |||
| Calculations resulting in #DIV/0! | Excel Worksheet Functions | |||
| Excel adds significant digits, resulting in errors in calculations | Excel Worksheet Functions | |||
| Formula for comparing 3 numbers and resulting in the lowest of the | Excel Worksheet Functions | |||
Threaded Mode
