Entering Dates

  • Thread starter Thread starter John
  • Start date Start date
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?
 
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top