Auto fill in and update current date/time whenever certain cells are filled

[Danisioni]

Excel sheet-testing 7.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	DAY				DATA							DATE/TIME
2	DAY 1				E2	F2	G2	H2				autofill date/time
3					E3	F3	G3	H3
4	DAY 2											autofill date/time
5
6	DAY 3											autofill date/time
7
Testing

Hi, I have tried to post this previously but have yet to get this solved.

I need Excel to automatically FILL-IN and UPDATE the current Date & Time in cell L2 (which is merged with L3), whenever any of the 8 Data cells (E2 to H3) in row 2 and 3 (Day 1) are FILLED for the first time.

Requirements:

1. The same should apply to each of the days below ("Day 2", "Day 3".. and so on infinitely). ​

2. Filling the Data cells should update the date/time cell of it’s own day only (and not the ones above or below). ​

3. Editing an already filled Data cell should not update the time.​

4. I should be able to manually edit the Date/Time cell if needed.​

5. If all Data cells of the day are empty then also the Date/Time cell of that day will remain empty.​

Preferences:

Formulas are preferred over VBA codes.​

Thanks

 

[Fluff]

Duplicate to: Auto fill in and update current date and time whenever certain cells are filled

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.