Date Help

M

Malcolm

I have linked two columns on a worksheet so that when I type in the date in
cell C6 it also appears in cell J6. I entered =$C$6 in J6, and this works
except sometimes I don’t need to use the date cells. My problem is in cell J6
the date appears as 1/0/00 until I type the date into cell C6. What am I
doing wrong?
Thanks,
Malcolm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

my first excel experience (share portfolio) 2
circular reference using vlookup 1
keep old cell value and new cell value 2
match formula needed 2
Autofill Date in Word 15.33 for Mac 0
Cell Required before Closing 1
use month in cell date to sum all relevant cells 2
End Date/Time adding business hours 1

Top