thanks a lot for ur response , however may it possible to display the hours
too like:
9/8/2005 01:00
9/8/2055 02:00
..
..
..
so on
"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