Auto filling semi-monthly dates

  • Thread starter Thread starter Lawdog
  • Start date Start date
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
 
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...
 
Back
Top