Auto filling semi-monthly dates

L

Lawdog

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

Thanks
 
S

Sheeloo

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
 
L

Lawdog

Thanks
--
Lawdog


Sheeloo said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill Date in Word 15.33 for Mac 0
Quarterly Data in Pivot Table 3
Need help with using Month as criteria for SUM(COUNTIFS(... 3
Advanced filter on last months results 6
i am trying to fill a column with dates in descending order 1
Help showing active months between two dates 5
Like to start using Access 1
referencing another sheet and using auto fill 10

Top