Summary of dates
I have a column of dates, 40000+ cells in mm/dd/yyyy format. All of the dates
fall within the same month; how do I show which month? I want to build this into a template so that next month I have inly to insert the dates, and I will see the month and year. Any help is appreciated. |
Summary of dates
Why not pick a cell to identify the month and have it simply be a reference
to one of the dates in the list, then format this cell as MMMM. Bob Umlas Excel MVP "billinr" wrote in message ... I have a column of dates, 40000+ cells in mm/dd/yyyy format. All of the dates fall within the same month; how do I show which month? I want to build this into a template so that next month I have inly to insert the dates, and I will see the month and year. Any help is appreciated. |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com