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 ...
Prevent Cells from Summing to a Negative Value or Vice Versa
Tutorial: How to prevent a range of cells from adding up to a negative value, or preventing the same...



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.