Setting up quarterly dates

  • Thread starter Thread starter Janice Davis
  • Start date Start date
J

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
 
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
 
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
 
Mark Graesser said:
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
Click to expand...
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)
Click to expand...

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
 
Back
Top