ExcelBanter - Auto filling semi-monthly dates

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Auto filling semi-monthly dates (https://www.excelbanter.com/new-users-excel/213647-auto-filling-semi-monthly-dates.html)

Lawdog

Auto filling semi-monthly dates

How do I autofill semi-monthly dates into a column. (ie Jan 1 2000 thru Dec
2008)

Thanks
--
Lawdog

Sheeloo[_3_]

Auto filling semi-monthly dates

If you want 1-Jan, 15-Jan,1-Feb, 15-Feb,...
then enter this in A1
=1/1/2008
then this in A2
=IF(DAY(A1)=1,A1+14,DATE(YEAR(A1),MONTH(A1)+1,1))
and copy down till you get 31-Dec

"Lawdog" wrote:

How do I autofill semi-monthly dates into a column. (ie Jan 1 2000 thru Dec
2008)

Thanks
--
Lawdog

Lawdog

Auto filling semi-monthly dates

Thanks
--
Lawdog

"Sheeloo" wrote:

If you want 1-Jan, 15-Jan,1-Feb, 15-Feb,...
then enter this in A1
=1/1/2008
then this in A2
=IF(DAY(A1)=1,A1+14,DATE(YEAR(A1),MONTH(A1)+1,1))
and copy down till you get 31-Dec

"Lawdog" wrote:

How do I autofill semi-monthly dates into a column. (ie Jan 1 2000 thru Dec
2008)

Thanks
--
Lawdog

All times are GMT +1. The time now is 05:56 AM.