| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date calculations resulting in negative numbers and averages
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 |
| 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
