Need formula for populating Date Status

[Freeman2022]

Greetings,

Column A shows Previous TimeStamp
Column B shows Current TimeStamp
Column C show Current Status

I'm trying to find a formula to populate for Column C

If time stamps are the same, it should say – No Change
If time stamps are different, it should say – Updated
If Current time stamps is blank it should say - Deleted

Sample Data

Previous TimeStamp	Current TimeStamp	Current Status
2016-03-08 21:08:45	2016-03-08 21:08:45
2017-05-31 19:17:03	2024-03-06 20:55:06
2017-03-31 20:24:23

 

[HighAndWilder]

Greetings,

Column A shows Previous TimeStamp
Column B shows Current TimeStamp
Column C show Current Status

I'm trying to find a formula to populate for Column C

If time stamps are the same, it should say – No Change
If time stamps are different, it should say – Updated
If Current time stamps is blank it should say - Deleted

Sample Data

Previous TimeStamp	Current TimeStamp	Current Status
2016-03-08 21:08:45	2016-03-08 21:08:45
2017-05-31 19:17:03	2024-03-06 20:55:06
2017-03-31 20:24:23

Does this work?

Summing Up only the Weekend Days from the Total.xlsm
	A	B	C
2	Previous TimeStamp	Current TimeStamp	Current Status
3	08/03/2016 21:08	08/03/2016 21:08	No Change
4	31/05/2017 19:17	06/03/2024 20:55	Updated
5	31/03/2017 20:24		Deleted
Sheet5

Cell Formulas
Range	Formula
C3:C5	C3	=IF(AND(ISNUMBER(A3),ISNUMBER(B3),B3=A3),"No Change",IF(AND(ISNUMBER(A3),ISNUMBER(B3),B3<>A3),"Updated",IF(ISBLANK(B3),"Deleted","")))

 

[Freeman2022]

Does this work?

Summing Up only the Weekend Days from the Total.xlsm
	A	B	C
2	Previous TimeStamp	Current TimeStamp	Current Status
3	08/03/2016 21:08	08/03/2016 21:08	No Change
4	31/05/2017 19:17	06/03/2024 20:55	Updated
5	31/03/2017 20:24		Deleted
Sheet5

Cell Formulas
Range	Formula
C3:C5	C3	=IF(AND(ISNUMBER(A3),ISNUMBER(B3),B3=A3),"No Change",IF(AND(ISNUMBER(A3),ISNUMBER(B3),B3<>A3),"Updated",IF(ISBLANK(B3),"Deleted","")))

No that doesn't work, it populates for the Deleted item but not for the No Change and Updated, it remains blank

 

[Joe4]

Formula to place in cell C2 and copy down:

=IF(TRIM(B2)="","Deleted",IF(B2=A2,"No Change","Updated"))

 

[Freeman2022]

Formula to place in cell C2 and copy down:

=IF(TRIM(B2)="","Deleted",IF(B2=A2,"No Change","Updated"))

View attachment 118544

Perfect that works!!! Thank you for your help!!! Greatly appreciated.

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[HighAndWilder]

Does this work?

Summing Up only the Weekend Days from the Total.xlsm
	A	B	C
2	Previous TimeStamp	Current TimeStamp	Current Status
3	08/03/2016 21:08	08/03/2016 21:08	No Change
4	31/05/2017 19:17	06/03/2024 20:55	Updated
5	31/03/2017 20:24		Deleted
Sheet5

Cell Formulas
Range	Formula
C3:C5	C3	=IF(AND(ISNUMBER(A3),ISNUMBER(B3),B3=A3),"No Change",IF(AND(ISNUMBER(A3),ISNUMBER(B3),B3<>A3),"Updated",IF(ISBLANK(B3),"Deleted","")))

But did the downloaded example work in your worksheet?

You need to check that the entry is not text.

 

[Joe4]

But did the downloaded example work in your worksheet?

You need to check that the entry is not text.

Not necessarily. Only they know the format of the data that can be in there.
It may not be a concern.

If they are TimeStamps added via VBA code, you can be pretty confident that they will always be valid date/time entries.