Using REPT funtion with dates between sheets and workbooks - help
 

I am trying to repeat dates in several different places, so that I only
have to type it once. However, when I use the REPT function I get a
number instead of a date format. I've tried to format the cells back to
date function, but it doesn't change.


--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=468286

The REPT function repeats 'whatever' the number of times you set it to, it
will only work with a date if you set it to repeat once which is obviously
pointless. I dont think thats what you want here. If you have the date in
for instance A6, in all the other cells enter =A6
Regards,
Alan.
"ROCKWARRIOR"
wrote in message
...

I am trying to repeat dates in several different places, so that I only
have to type it once. However, when I use the REPT function I get a
number instead of a date format. I've tried to format the cells back to
date function, but it doesn't change.


--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile:
http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=468286

If you're "master" cell is A1 on Sheet1, you could use:

=A1
or better
=if(a1="","",a1)
for cells on the same sheet.

or
=sheet1!a1
or better
=if(sheet1!a1="","",sheet1!a1)

(you may have to format the cell with the formula as a date.)

ROCKWARRIOR wrote:

I am trying to repeat dates in several different places, so that I only
have to type it once. However, when I use the REPT function I get a
number instead of a date format. I've tried to format the cells back to
date function, but it doesn't change.

--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=468286

--

Dave Peterson

Thanks David! That works great!


--
ROCKWARRIOR
------------------------------------------------------------------------
ROCKWARRIOR's Profile: http://www.excelforum.com/member.php...o&userid=27091
View this thread: http://www.excelforum.com/showthread...hreadid=468286