How do I change a date in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build a sheet for tracking inventory. I want to put a cell
beside the "received" and "issued" cells to record last entry date. Anybody
out there have a method to do this?
 
Just put an target.offset(0,1)=date in a worksheet_change event of the sheet
code.
 
Sorry but I reckon that was a little over my head, maybe we could try again?
 
You must log in or register to reply here.

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

Show date based on conditions 0
Date refrencing 3
Update cell value based on name and specific date 1
display date of today in cell X when number >0 in cell Y 2
How to update a cell after a calculation? 1
Adding days to a date - changed in Excel 2010 8
Excel Average dates help 0
Excel 2003 make 1 date cell automatically change another date cell 3

Back
Top