How to Add Date to One Cell if Multiple Cells Contain a Value

**craywall** · 05-02-2019, 11:54 AM

I want B2 to contain the date the data was entered from any of the cells F2:P2 contain a value.
I tried using the formula below, but it only gives today's date. Everytime I open it, the data entered goes to the current date, not the date the data was entered.
=IF(COUNTA(F17:P18)>0,TODAY(),"")

**MrShorty** · 05-02-2019, 12:18 PM

That sounds like you want a timestamp. One approach for entering time stamps in Excel is this: https://chandoo.org/wp/timestamps-excel-formula-help/

**craywall** · 05-02-2019, 06:09 PM

That sort of answered my question, but I'm looking for a specific formula to use for this function.

**MrShorty** · 05-02-2019, 06:21 PM

Is there something you did not understand about chandoo's formula: =IF(C3<>"",IF(B3="",NOW(),B3),"") in cell B3.

The only thing really different about your scenario is that you are monitoring multiple cells and want to add a timestamp if something is entered into any of them. In chandoo'd formula, the C3<>"" is the part that is monitoring the data entry cell. To expand it to monitor multiple cells, one might use the COUNTA() function like you attempted in your original formula =IF(COUNTA(C3:F3)<>0,IF(B3="",TODAY() or NOW(),B3),""). Note that this will time stamp when the first cell in the range has data entered, but will not time stamp subsequent entries in the range.

In your case, where you want to monitor F2:P2 and time stamp in B2, B2 becomes =IF(COUNTA(F2:P2)<>0,IF(B2="",TODAY(),""),"")

**craywall** · 05-03-2019, 02:54 PM

Once again,

I want the date entered if there is data entered in a specified row. Neither of these formulas work for that.
What I want is:
B2 to display the date if any data is entered from F2:P2. If nothing is entered I want the screen to be blank. This formula =IF(COUNTA(F17:P18)>0,TODAY(),"") does that, but it does not retain the date the data was entered. Instead, it displays today's date. The timestamp example that was given does not work. What exact formula can I use for this?

**MrShorty** · 05-03-2019, 03:32 PM

Curious. It seems to work just fine for me in my spreadsheet. Have you enabled iteration? What do you mean by "it doesn't work"?

**craywall** · 05-06-2019, 07:33 PM

Actually, enabling iterations and changing the maximum to 1 worked. Thank you for help

How to Add Date to One Cell if Multiple Cells Contain a Value

LinkBack

Thread Tools

Rate This Thread

Display

How to Add Date to One Cell if Multiple Cells Contain a Value

Re: How to Add Date to One Cell if Multiple Cells Contain a Value

Re: How to Add Date to One Cell if Multiple Cells Contain a Value

Re: How to Add Date to One Cell if Multiple Cells Contain a Value

Re: How to Add Date to One Cell if Multiple Cells Contain a Value

Re: How to Add Date to One Cell if Multiple Cells Contain a Value

Re: How to Add Date to One Cell if Multiple Cells Contain a Value

Thread Information

Users Browsing this Thread

Similar Threads

How to add date to one cell if multiple cells contain a value

Select multiple multiple cells adjacent to a date and populate a table

Macro to find Date Cells > Current Date and delete everything to left of that cell

[SOLVED] Conditional Formatting Multiple Cells Based On Date In Other Cell

Autopopulate Saturdays in multiple cells based on month date in another cell

How to associate multiple cells associated with one cell until a different date is entered

[SOLVED] Date and time stamping multiple cells for multiple entries.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions