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

**craywall** · 03-29-2019, 05:38 PM

I tried this function =IF(ISNUMBER(F17),(TODAY()),""), but it only works for that one cell. I want B17 to contain a date if any of the cells F17:P17 contain a value. I tried =IF(ISNUMBER(F17:P18),(TODAY()),""), but that does not work. I just want a date to appear if I add a value(s) into any one of these cells.

**Roel Jongman** · 03-29-2019, 05:58 PM

you can use

Formula:

Please Login or Register  to view this content.

COUNTA counts how many cells are filled.

**craywall** · 03-30-2019, 11:52 AM

Thank you. That's exactly what I was looking for!

**craywall** · 04-23-2019, 12:40 PM

Actually, this works, but it continues to go to the current date. I want the data to remain on the date entered.

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

Thread Information

Users Browsing this Thread

Similar Threads

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

Filling cells with 3 different colors based on date in cell and todays date

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

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions