MAx Date and Time

[vmjan02]

I have this column and nee dto find the max date and time in one function is there a way there may will be woth date and time,
any other function

TASK LAST UPDATE DATE

9/1/2023 21:11

9/1/2023 18:40

9/1/2023 15:01

9/1/2023 21:11

9/2/2023 14:46

9/4/2023 21:43

9/1/2023 19:47

9/2/2023 15:30

9/1/2023 21:57

9/3/2023 15:51

9/1/2023 18:53

9/1/2023 14:56

9/3/2023 15:33

9/2/2023 18:00

9/2/2023 16:35

9/3/2023 10:25

9/1/2023 21:11

9/4/2023 15:25

9/1/2023 20:24

9/1/2023 13:45

9/1/2023 21:11

9/1/2023 21:11

9/1/2023 2:23

9/1/2023 21:11

9/1/2023 21:11

9/1/2023 13:08

9/1/2023 19:10

9/1/2023 0:57

9/3/2023 11:01

9/1/2023 16:46

9/2/2023 20:17

9/1/2023 21:11

9/1/2023 21:11

9/3/2023 11:13

9/1/2023 21:05

9/1/2023 15:10

9/2/2023 15:23

9/1/2023 20:58

9/5/2023 14:37

9/1/2023 17:57

9/1/2023 20:11

9/1/2023 20:29

9/1/2023 21:11

9/1/2023 21:08

9/1/2023 17:12

9/1/2023 20:02

9/1/2023 21:08

 

[ranman256]

Max() DOES work with date/time

=MAX(A1:A48)

 

[vmjan02]

Max() DOES work with date/time

=MAX(A1:A48)

yes it don't work any other soultion

 

[ranman256]

what 'solution'?

 

[vmjan02]

what 'solution'?

apart from Max function is there any other function or way which can give max with respect to date and time
max only works on date and not time

 

[Fluff]

The Max function does work with date & time

Fluff.xlsm
	A	B
1	TASK LAST UPDATE DATE
2	09/01/2023 21:11	09/05/2023 14:37
3	09/01/2023 18:40
4	09/01/2023 15:01
5	09/01/2023 21:11
6	09/02/2023 14:46
7	09/04/2023 21:43
8	09/01/2023 19:47
9	09/02/2023 15:30
10	09/01/2023 21:57
11	09/03/2023 15:51
12	09/01/2023 18:53
13	09/01/2023 14:56
14	09/03/2023 15:33
15	09/02/2023 18:00
16	09/02/2023 16:35
17	09/03/2023 10:25
18	09/01/2023 21:11
19	09/04/2023 15:25
20	09/01/2023 20:24
21	09/01/2023 13:45
22	09/01/2023 21:11
23	09/01/2023 21:11
24	09/01/2023 02:23
25	09/01/2023 21:11
26	09/01/2023 21:11
27	09/01/2023 13:08
28	09/01/2023 19:10
29	09/01/2023 00:57
30	09/03/2023 11:01
31	09/01/2023 16:46
32	09/02/2023 20:17
33	09/01/2023 21:11
34	09/01/2023 21:11
35	09/03/2023 11:13
36	09/01/2023 21:05
37	09/01/2023 15:10
38	09/02/2023 15:23
39	09/01/2023 20:58
40	09/05/2023 14:37
41	09/01/2023 17:57
42	09/01/2023 20:11
43	09/01/2023 20:29
44	09/01/2023 21:11
45	09/01/2023 21:08
46	09/01/2023 17:12
47	09/01/2023 20:02
48	09/01/2023 21:08
Sheet5

Cell Formulas
Range	Formula
B2	B2	=MAX(A2:A48)

 

[ranman256]

yeah, like i said.

 

[vmjan02]

aggred but if i do =max(A2:A48)-1 then it only minus the date and not time
so trying to fix this if date is -1 then it should take the time as well.

 

[Scott Huish]

If you have this in a cell
9/3/2023 10:25
and subtract 1 you are subtracting 1 day
9/2/2023 10:25

What are you expecting to happen?

 

[vmjan02]

If you have this in a cell
9/3/2023 10:25
and subtract 1 you are subtracting 1 day
9/2/2023 9:15

the result is 9/2/2023 10:25 with max function