| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date calculations resulting in negative numbers and averages
=IF(DAYS360(C3,D3)<0,"",DAYS360(C3,D3))
-- Gary''s Student - gsnu200845 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date calculations resulting in negative numbers and averages
Perfect...thank you for today's and yesterday's help!
"Gary''s Student" wrote: =IF(DAYS360(C3,D3)<0,"",DAYS360(C3,D3)) -- Gary''s Student - gsnu200845 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date calculations resulting in negative numbers and averages
You are quite welcome.
Thank you for the feedback. -- Gary''s Student - gsnu200845 "Radrays" wrote: Perfect...thank you for today's and yesterday's help! "Gary''s Student" wrote: =IF(DAYS360(C3,D3)<0,"",DAYS360(C3,D3)) -- Gary''s Student - gsnu200845 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
