Formatting calendar dates on spreadsheet

Microsoft Excel 2008 for mac
July 1, 2010 at 12:14:32
Specs: Macintosh
I want to format an invoice so that the dates of
the month change to the current month just by
entering the date one time in the first cell. The
invoice would include all the days of the month.
How do I do this? Thanks for your help.

See More: Formatting calendar dates on spreadsheet

Report •

July 1, 2010 at 14:14:55

You can try this:
In cell A1 enter =DATE(YEAR(TODAY()),MONTH(TODAY()),1)
This will return the first day of the current month & year
or just enter the date for the first of the required month.
The date must be in a format Excel recognizes as a date.

In cell A2 enter =A1+1
This will give the second of the month

Drag the formula in cell A2 down to A28
This will give the first 28 days.

In cell A29 enter this formula: =IF(DAY($A$1+28)<>29,"",A28+1)
This tests whether 28 days after the 1st of the month is 29 (or 1 - i.e. 1st of next month)
If it isn't 29, it returns "", else it returns the date

The same approach is used for A30 and A31
A30 =IF(DAY($A$1+29)<>30,"",A29+1)
A31 =IF(DAY($A$1+30)<>31,"",A30+1)

Format all cells with the required date format.

Hope this is the sort of thing you were looking for.


Report •

July 1, 2010 at 15:21:57
Thanks so much. That was exactly what I was looking for!!

Report •

July 2, 2010 at 03:23:24
Glad to have helped, and thanks for the feedback.



Report •

Related Solutions

Ask Question