Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Power users need your help €“ calculation based on a date
Power users need your help €“ with a calculation that is based on a date
function and remains a value after the date passes. The logic: Add several cells, There are 8 rows in the totals column The column is then summed at the bottom. The objective is for the column of numbers to sum when the date equals a spacific date or at the end of the month. The challenge is when the calendar date changes the total from the previous day does not change. Or is there a formula that will only sum once on a specific date and the total then becomes a value so it does not change when the date changes? This is as far as I got; =IF(Y7=DATEVALUE("9/30/2005"),(SUM(Y12:Y31)/COUNT(Y12:Y31)),0) Grateful for any assistance. best regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to set up quarterly windows based on a date | New Users to Excel | |||
Current date formula based on month | Excel Discussion (Misc queries) | |||
Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
Calculation based with Range of Date | New Users to Excel | |||
Counting unique records based on date range | Excel Worksheet Functions |