Setting up quarterly dates

[Janice Davis]

I am not real proficient with excel and I need help. I asked another newsgroup how to set up the function so that every three months a new date on the first day of the new month would appear. For example. I want to set up a date system like this

1/1/04
4/1/04
7/1/04
10/1/04
1/1/05
and so on.

What is the best way to do this?
The answer given to me by someone else was =date, date unit=month, step value=3
I tried this and it didn't work.
I was also told to cut and paste the first couple of cells to the rest of the column, that didn't work either. Please help

Janice

 

[Mark Graesser]

Janice,
To do this with a function use:

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

You can also do this with Fill. Enter 1/1/04 in a cell and 4/1/04 in the cell directly below. Select both cells and then drag down on the fill handle. You should get the first day of every third month.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Janice Davis wrote: -----

I am not real proficient with excel and I need help. I asked another newsgroup how to set up the function so that every three months a new date on the first day of the new month would appear. For example. I want to set up a date system like this

1/1/04
4/1/04
7/1/04
10/1/04
1/1/05
and so on.

What is the best way to do this?
The answer given to me by someone else was =date, date unit=month, step value=3
I tried this and it didn't work.
I was also told to cut and paste the first couple of cells to the rest of the column, that didn't work either. Please help

Janice

 

[Peo Sjoblom]

Put 01/01/04 in A1, in A2 put

=DATE(YEAR(A1),MONTH(A1)+3,1)

copy down by grabbing the lower right corner of A2 with the mouse and
drag downwards. Once you are done you can copy and paste special as values
in place
You can also put

01/01/04 in A1
04/01/04 in A2, select both cells and copy down

--

Regards,

Peo Sjoblom


I am not real proficient with excel and I need help. I asked another
newsgroup how to set up the function so that every three months a new date
on the first day of the new month would appear. For example. I want to set
up a date system like this

1/1/04
4/1/04
7/1/04
10/1/04
1/1/05
and so on.

What is the best way to do this?
The answer given to me by someone else was =date, date unit=month, step
value=3
I tried this and it didn't work.
I was also told to cut and paste the first couple of cells to the rest of
the column, that didn't work either. Please help

Janice

 

[Janice Davis]

Janice,
To do this with a function use:

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

You can also do this with Fill. Enter 1/1/04 in a cell and 4/1/04 in the

cell directly below. Select both cells and then drag down on the fill
handle. You should get the first day of every third month.

Good Luck,
Mark Graesser
(e-mail address removed)

Thank you, thank you, thank you! It took me a little time to figure out the
fill handle, but I got it! Thanks so much. I guess that is what the other
person was trying to explain to me too. Thanks!

Janice