How do I create a custom fill series for dates?

J

Jeff

I want to create a custom fill series for dates. Example: For the first
four (4) cells I want 5-1-07, the next four (4) cells I want 5-2-07, the next
four (4) cells in want 5-3-07,... I want this to continue in series for as
long as I drag down "the fill handle".
 
M

Max

One way ..

Put in any starting cell, eg in B2:
= --"5Jan2007"+INT((ROW(A1)-1)/4)
Format B2 as date to taste, then copy down as far as required
 

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

Top