constant date

hello
i want consatan date in cell like
a1:a24=1/1/2012
a25:a48=1/2/2012
a:49:a73:1/3/2012
.
.

.
thank you

Hi

Does this help:

date(2012,1,1)
Or inase you use date as a reference:
a1 holds 1/1/2012
Date(year(a1),month(a1),day(a1))

bart

Are you looking to have the date there to represent 24 hours where each row is 1 hour?

If so, cell one can contain your starting date and cell 2 and onward can contain the following equation referencing cell 1:

Please Login or Register  to view this content.

This will add 1 hour to the date while still showing the M/D/YYYY in the cell.