# Trying to see if possible a formula on this task?

#### zone709

##### Well-known Member
Trying to use a formula to add the word UPDATED in cell (I). If any changes in value from column B to H then to add the word UPDATED. Though if no changes occur by certain day then leave blank. So lets say its Wednesday right. Then number (4) example shouldn't have the word updated in cell (I)and leave that blank cell blank. Since its Wednesday and has 0 Value.

Or if there is a better way to do it. I am open to it thanks

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
G
H
I
J
1
9TH (1)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Start​
2
Reg Hrs
0
0
0
0
0
3
OT Hrs
0
0
0
0
0
0
0
4
DT Hrs
0
0
0
0
0
0
0
Avg People
5
Total Employees
0
0
0
0
0
0
0.0
6
7
9TH (2)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
8
Reg Hrs
25
0
0
0
0
UPDATED
<--Want to add the word update when a change happens​
9
OT Hrs
30
0
0
0
0
0
0
10
DT Hrs
35
0
0
0
0
0
0
Avg People
11
Total Employees
0
0
0
0
0
0
0.0
12
13
9TH (3)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
No changes within a 24 hour day​
14
Reg Hrs
25
0
0
0
0
15
OT Hrs
30
0
0
0
0
0
0
16
DT Hrs
35
0
0
0
0
0
0
Avg People
17
Total Employees
0
0
0
0
0
0
0.0
18
19
9TH (4)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
A change happened again on Tuesday​
20
Reg Hrs
25
50
0
0
0
UPDATED
21
OT Hrs
30
10
0
0
0
0
0
22
DT Hrs
35
5
0
0
0
0
0
Avg People
23
Total Employees
0
0
0
0
0
0
0.0
24
 Sheet: Sheet1

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Replies
0
Views
255
Replies
27
Views
2K
Replies
0
Views
499
Replies
18
Views
25K
Replies
2
Views
561

1,191,582
Messages
5,987,468
Members
440,097
Latest member
Wint

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back