View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adrian1962 Adrian1962 is offline
external usenet poster
 
Posts: 3
Default 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.