pinning an @today date and time

  • Thread starter Thread starter bflorox
  • Start date Start date
B

bflorox

I have a 2-column ss. One column is a value and the other is the current
date and time the value was entered. I have set the date and time to appear
only if a value is entered in the neighboring column. I want the date and
time to always be there as the date and time it was when it was created. How
can I pin that value so they don't change every time I open up the ss?
Thanks.
 
date and time are from @now, not @today. I don't want those values to change
every time I make an entry.
 
Sorry, meant to post to "Worksheet Functions". ? has been answered there.

Thanks.
 
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

Pivot table macro filter data between yesterday and today (date+time) 0
Line graph w/ recent data 3
static "now" values 5
today's date static 1
date and time on line chart 1
How do I include a date column in the Axis in Excel? 1
How to enter start and end date/time in excel based on some specific value. 7
Excel Dragging countif formula with changing criteria 3

Back
Top