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
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:
This will add 1 hour to the date while still showing the M/D/YYYY in the cell.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks