Excel Forum

Excel Magic Trick 325: Aggregate Daily Cost to Monthly Cost

See a formula that takes a fixed daily cost and calculates the monthly total for months with different number of days. See the DAY, EOMONTH, DATE, YEAR, MONTH functions. See formulas that work in Excel 2007 and Excel 2003. See how to: Tool menu, Add-Ins, Analysis ToolPak.

DATE function, DAY function, YEAR function, MONTH function, and EOMONTH function.

Got a Question? Ask it Here in the Forum.