I have what may seem a small problem.
I am currently building an Excel workbook that is for tracking attendance daily, weekly, monthly, and yearly.
Each workbook is assigned to a specific person for a one year period. Ex. 12/1/2013 to 11/30/2014
When the dates are entered a column automatically fills in the months of that year based on these dates. Ex. Dec-13, Jan-14, Feb-14, and so forth
I was given a simple formula to create the column of dates which has worked in most cases. cell = value of previous cell containing a month+ 30. In other words, if A1 contains Dec-13 then A2 will automatically become Jan-14...etc...
However, some months have fewer days or more days. Depending on the one year periods begin date it can autopopulate the same month twice.
Example: 1/1/2014 begin date generates the following:
Jan-14
Jan-14
Mar-14
Apr-14
May-14
May-14
Jun-14
Jul-14
Aug-14
Sep-14
Oct-14
Nov-14
Dec-14
What can I use to auto populate the correct months instead of using the simple +30 above?
Bookmarks