database with TODAY function; need absolute date

**HeyInKy** · 08-26-2014, 10:32 AM

So I have an excel database where rows of data get updated on a regular basis. FYI, the data is transferred from a userform which puts it in the next empty row.

I want a column where the date is recorded when the data was entered. The data transfer starts in column C, and I have this in the B column:

Formula:

=IF(AND(C2<>""),(TODAY()),"")

My question is, will this formula retain the date when C2 has data, or if I open this file tomorrow, let's say for instance, would it show tomorrow's date? In other words, is the formula absolute or does it refresh?

**Norie** · 08-26-2014, 10:34 AM

Why don't you add code that puts the current date in column C (or is it B) of the row you are transferring data to?

**HeyInKy** · 08-26-2014, 10:36 AM

Would be happy to if you could help me with the code! I'm much more comfortable with standard excel formulas than with VBA.

**Norie** · 08-26-2014, 10:38 AM

The code is really straightforward.

For example to put the current date in column C on the next empty row.

NextRow = Range("A" & Rows.Count).End(xlUp).Row

Range("C" & NextRow).Value = Date

Obviously you'll have different code for finding the next empty row etc but that's the general idea.

**HeyInKy** · 08-26-2014, 10:39 AM

Cool. Thanks...

database with TODAY function; need absolute date

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

database with TODAY function; need absolute date

Re: database with TODAY function; need absolute date

Re: database with TODAY function; need absolute date

Re: database with TODAY function; need absolute date

Re: database with TODAY function; need absolute date

Thread Information

Users Browsing this Thread

Similar Threads

How to have =Today() Function keep today's date adn nt change tomorrow or in future

SUMIF within date range as a function of today()'s date

MAX figure within a date range as a function of today()'s date

=TODAY() function to fix the date

[SOLVED] Today() or Date() function help

Bookmarks

Bookmarks

Posting Permissions