| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing values based on calendar dates
I have an aging report, and I have a single row of sequential dates that span
six months, and its is a dynamic row based on the date I type in the first cell. Below the row are dollars. How does one compose a formula to automatically sum 31 columns if it a month is 31 days, 30 columns for a 30 day month, or 28 columns for 28 days for a February? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing based on values in other worksheets | Excel Worksheet Functions | |||
| Calendar - vlookup based on dates | Excel Worksheet Functions | |||
| Creating calendar that autopopulates dates based on event date ent | Excel Worksheet Functions | |||
| Summing based on a range of dates | Excel Discussion (Misc queries) | |||
| Summing values b/t two dates | Excel Discussion (Misc queries) | |||
Threaded Mode
