Using REPT funtion with dates between sheets and workbooks - help

[ROCKWARRIOR]

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.

[Alan]

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" <ROCKWARRIOR.1vgoib_1126890307.0174@excelforum-nospam.com>
wrote in message
news:ROCKWARRIOR.1vgoib_1126890307.0174@excelforum-nospam.com...
>
> 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]

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

[ROCKWARRIOR]

Thanks David! That works great!