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
|