Currently Being ModeratedJul 4, 2013 5:52 AM (in response to Twocybers)
Column A contains cells formatted as Date-and-Time, with the Time hidden. Any day of the month will do because
calculates the end of that month. Year in Column A will be important in February (Leap Years ).
The zero in the formula means zero offset (i.e. that month). See the Function Browser in Numbers and look up EOMONTH.
Format cells using Inspector > Cells > Cell format.
The Numbers User Guide, from the Help Menu in Numbers, is a good read.
Currently Being ModeratedJul 4, 2013 6:58 AM (in response to Twocybers)
Your approach is the as simple a one I can imagine. There may be slightly easier ways to Fill and to write the expression for end of month, but it's all very basic. You may not have considered how you will eliminate the column with the first of the month dates. If you Select the end of month calculation column, Copy, and Paste Values, you can then safely delete the first of month column.
Currently Being ModeratedJul 8, 2013 10:56 PM (in response to Twocybers)
This is a variation on what Ian has suggested. It eliminates the need for the second column.
Cell A2 contains the initial date.
A3 contains the formula =EOMONTH(A2,1)
The formula is filled down through the rest of column A.
As can be seen in the second and second last rows containing dates, leap year is not an issue.
As Jerry has noted, you may want to replace the formulas with the calculated dates, To do so:
- Click any cell in the table to show the column and row reference tabs.
- Click the reference tab for column A to select that column.
- Go Edit > Paste Values.