Entering Dates

J

John

I want to be able to enter the date in cell A1 and have it
complete the rest of the dates of the month in the other
cells of row A.
I usually just enter =A1, =A1+1, =A1+2, etc.,but now I
need it to recognize what months are 28 days and what days
are 30 or 31. What is the function to make this work?
 
T

Trevor Shuttleworth

John

try using:

A1 = start date
A2 = A1 +1
A3 = A2 +1
A4 = A3 +1
and so on

This will cope with the all months. You'll simply roll over into the next
month

Regards

Trevor
 
N

Norman Harker

Hi John!

If you want to "roll over" to the next month, then Trevor's approach
is best.

If you want to end the series at the end of the month, then try:

=IF(A1="","",IF(A1=DATE(YEAR(A1),MONTH(A1)+1,0),"",A1+1))
Copied across to AE1

It can probably be made more efficient using EOMONTH but that relies
on Analysis ToolPak.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top