How do I get a repeating date format in Excel

Microsoft Office excel 2003
September 2, 2010 at 05:24:29
Specs: Windows XP
I am trying to make a spreadsheet that has repeating dates. I need the date to repeat twice. Is there a way to do this with a formula or function? See example below. Thanks!

8/1/2010
8/1/2010
8/2/2010
8/2/2010


See More: How do I get a repeating date format in Excel

Report •

#1
September 2, 2010 at 06:14:19
Hi,

Put your first date in cell A1.
Enter these formulas in the following cells:
A2 - =A1
A3 - =A2 + 1
A4 - =A3

Format cells with required date format.

Now select cells A3 and A4.
Drag them down column A as far as required and you will have pairs of dates:

	A
1	01-Aug-10
2	01-Aug-10
3	02-Aug-10
4	02-Aug-10
5	03-Aug-10
6	03-Aug-10
7	04-Aug-10
8	04-Aug-10
9	05-Aug-10
10	05-Aug-10
11	06-Aug-10
12	06-Aug-10

Regards

Report •

#2
September 2, 2010 at 07:26:49
Awesome! Thanks so much!

Report •

#3
September 2, 2010 at 10:20:31
You're welcome.

Regards

Humar


Report •
Related Solutions


Ask Question