i wish to insert vlues from 1/1/1977 in this way ur method starts from "today"

"Bonzo123" wrote:


In address A1 type in
=today()+"00:00"

In the A2 type in

=A1+1/24

Drag this formula down

Regards


--
Bonzo123
------------------------------------------------------------------------
Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182
View this thread: http://www.excelforum.com/showthread...hreadid=465824