LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default SUM if date < 30 days away

I have two columns, one with the amount due, and one with due dates. The due
dates are changing periodically, and I want my sum to only include amounts
that are due within 30 days from the current date.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Number of days from one date to another Renz09 Excel Discussion (Misc queries) 2 May 3rd 06 10:18 AM
I want any date 90 days or older from current date change color Big Abalone Excel Worksheet Functions 5 April 23rd 06 05:01 AM
formula to calculate future date from date in cell plus days Chicesq Excel Worksheet Functions 8 November 3rd 05 12:25 PM
set a date in columns 7 days apart Squirel Eater Excel Worksheet Functions 8 June 26th 05 02:00 AM
How would I change a date cell to decrease it by business days? CNGracin Excel Discussion (Misc queries) 3 December 15th 04 05:20 PM


All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"