| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a range by date over 90 days older than today
Thank you so much it worked
"SteveG" wrote: Sorry, thought you wanted to count the number of instances that the invoice was over 120 days. Try this. You need to alter this formula for each # of days you have. 30,60,90,120. Using the dates you have then. 30 days =SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+130),($C$2:$C$6)) 60 days =SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+160),($C$2:$C$6)) 90 days =SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+190),($C$2:$C$6)) 120 days =SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+1120),($C$2:$C$6) ) Your results should actually be 30 - $400 60 - $300 90 - $300 120 - $200 120 days from today would be 10/20/2005. If you want to include the Text phrase in your example then use this and modify as needed. ="Total over 30 days"&" $"&SUMPRODUCT(--(DATEDIF($B$2:$B$6,TODAY(),"d")+130),($C$2:$C$6)) Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=513244 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formula Needed-Business Days | Excel Discussion (Misc queries) | |||
| How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions | |||
| Date Range and calculation | Excel Worksheet Functions | |||
| Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
Threaded Mode
