|
Home
About
Excel Tip
Training
Consulting
Forum
News
Store
Advertise with us
» Calculating the Date at the End of a Month
CATEGORY -
Excel Dates
VERSION -
All Microsoft Excel Versions
To calculate the date at the end of a month:
Use the EOMONTH function.
Screenshot // Calculating the Date at the End of a Month
Book Store:
Excel VBA books
Accounting books
Business Plans
MS Office books
Taxes books
VIEW ALL BOOKS
Recommended Books:
Special Edition Using Microsoft Office XP
Investing in Real Estate, Fourth Edition
Excel Charts
Microsoft Windows XP Inside Out
The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
Email Tip
Print Tip
Add to My Tips
Rate This Tip
1
2
3
4
5
Rating:
2.47
Views:
26227
how do you calculate columns by date
Peggy Yarborough
I want to calculate totals in a column, by date in another column.
01/01/06 thru the end of the month
I want to end with totals for the month of jan, feb etc
date amt total jan
01/01/06 212.00 212.00
01/06/06 224.00 436.00
Click here to post comment
For Registered Users
Click here to Regiser
For Guest
Name
Comment Title
Comments
01/01/06 thru the end of the month
I want to end with totals for the month of jan, feb etc
date amt total jan
01/01/06 212.00 212.00
01/06/06 224.00 436.00