| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto filling semi-monthly dates
How do I autofill semi-monthly dates into a column. (ie Jan 1 2000 thru Dec
2008) Thanks -- Lawdog |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate date on Semi-Monthly Basis | Excel Discussion (Misc queries) | |||
| Monthly Mortgage payments for a Semi annual compounding rate | Excel Worksheet Functions | |||
| Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) | |||
| Number of semi-monthly periods between 2 dates | Excel Worksheet Functions | |||
| Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions | |||
Linear Mode
