Using REPT funtion with dates between sheets and workbooks - help

[ROCKWARRIOR]

I am trying to repeat dates in several different places, so that I onl
have to type it once. However, when I use the REPT function I get
number instead of a date format. I've tried to format the cells back t
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" <[email protected]>
wrote in message
news:[email protected]...

 

[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]

Thanks David! That works great!