Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Insert and Manage Page Breaks in Excel
Tutorial: How to insert, remove, and manage page breaks in Excel.  This can be rather annoying and...
Get the Last Day of the Month in Excel
Tutorial: How to get the last day of the month, including the date and day of week, for any date in ...



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.