Colleagues using Wyse machines that do not have O365 on

[joz110820]

Hi everyone, happy holidays to you all.

I posted this thread on 30 November Only one colleague is having this issue with my spreadsheet, what could it be? and someone kindly informed me that the issue was likely due to the colleague having an older version of excel (issue is that formulas I have implemented are not compatible with their version of excel).

I contacted IT who informed us that Wyse machines in that office will not be having O365 added due to funding and now several staff members who are using this database are reporting the same issue who use Wyse. My question is, are there any more 2007 compatible formulas that I can use in H and I

Training Figures.xlsx
	B	C	D	E	F	G	H	I	J	K	L
1	Start Date	Orientation to B/F policy	Initial Training	Unicef Training	Attended 1 day update	Attended Practical skill review	Latest Training	Next due	Booked?	Turas	Turas module completed?
2	01/10/2004				21/06/2022	04/04/2019	21/06/2022	21/06/2025		06/06/2022
3	04/01/2022	27/04/2022							08/03/2023
4	19/11/2018				21/06/2022		21/06/2022	21/06/2025		20/06/2022
5	02/07/2012					2020
6	11/05/2020				21/06/2022	20/01/2021	21/06/2022	21/06/2025
7	13/11/2006				23/01/2020	13/02/2020	23/01/2020	23/01/2023
8	19/03/2007					2020
9	01/10/2004				23/01/2020	05/02/2020	23/01/2020	23/01/2023
10	01/04/2010				21/06/2022		21/06/2022	21/06/2025
11	01/10/2004				17/09/2020	21/10/2020	17/09/2020	17/09/2023
12	29/10/2014				09/06/2022		09/06/2022	09/06/2025
13	13/07/2015				24/02/2020	07/10/2020	24/02/2020	24/02/2023
14	01/04/2010				21/06/2022		21/06/2022	21/06/2025
15	02/05/2022	17/05/2022			09/06/2022		09/06/2022	09/06/2025		05/05/2022
16	14/05/2017					30/04/2019	16/11/2022	16/11/2025		05/11/2022
17	18/08/2015					2021
18	01/10/2004				12/01/2021	26/01/2021	12/01/2021	12/01/2024
19	01/04/2016				21/06/2022		21/06/2022	21/06/2025
20	18/04/2022	27/04/2022	01/07/2021			In Grampion	01/07/2021	01/07/2024
21	26/09/2022		14/04/2021			2021	14/04/2021	14/04/2024
22	27/04/2020	27/04/2022							08/03/2023
23	01/10/2004				23/01/2020	18/02/2020	23/01/2020	23/01/2023
24	01/10/2004				12/05/2022	21/11/2018	12/05/2022	12/05/2025
25	14/09/2015				23/01/2020	05/02/2020	23/01/2020	23/01/2023
26	09/04/2012				12/05/2022	07/07/2020	12/05/2022	12/05/2025
27	24/04/2017					2021
28	31/10/2016				14/04/2021	12/05/2021	14/04/2021	14/04/2024
29	09/05/2016				18/08/2022	2019	18/08/2022	18/08/2025
30	20/02/2012					14/05/2019	16/11/2022	16/11/2025
31	13/07/2015				21/02/2019	02/04/2019	21/02/2019	21/02/2022
32	05/11/2007				12/05/2022	10/12/2018	12/05/2022	12/05/2025
33	08/09/2004				23/01/2020	17/02/2020	23/01/2020	23/01/2023
34	24/09/2018				17/09/2020	2020	17/09/2020	17/09/2023
35	01/03/2004				21/06/2022	16/05/2019	21/06/2022	21/06/2025		21/06/2022
36	23/01/2017				12/05/2022	07/07/2022	12/05/2022	12/05/2025		10/05/2022
37	04/12/2006				08/11/2018	19/03/2019	08/11/2018	08/11/2021
38	31/07/2006				27/02/2020	29/10/2020	27/02/2020	27/02/2023
39	25/01/2019				12/05/2022		12/05/2022	12/05/2025
40	06/12/2010				17/09/2020	21/10/2020	17/09/2020	17/09/2023
41	02/09/2015				15/12/2020	18/01/2021	15/12/2020	15/12/2023
42	16/04/2012				12/05/2022	27/06/2022	12/05/2022	12/05/2025
43	13/04/2012				12/01/2021	03/02/2021	12/01/2021	12/01/2024
44	29/07/2013				12/05/2022		12/05/2022	12/05/2025
45	06/11/2014				21/06/2022		21/06/2022	21/06/2025
46	06/04/2009				12/05/2022		12/05/2022	12/05/2025
47	09/09/2015				09/06/2022		09/06/2022	09/06/2025
48	22/05/2017					2021
49	01/04/2010					2019
50	29/09/2014				12/05/2022		12/05/2022	12/05/2025
51	04/10/2004				12/01/2021	26/01/2021	12/01/2021	12/01/2024
52	19/04/2016				21/06/2022		21/06/2022	21/06/2025
53	07/03/2018				12/01/2021	26/01/2021	12/01/2021	12/01/2024
54	07/11/2011				29/08/2017	27/09/2017	29/08/2017	29/08/2020
55	13/03/2020				21/06/2022	02/06/2019	21/06/2022	21/06/2025
56	01/10/2004				12/05/2022		12/05/2022	12/05/2025
57	02/09/2015				23/01/2020	03/02/2020	23/01/2020	23/01/2023
58	05/09/2016				21/06/2022		21/06/2022	21/06/2025		27/05/2022
59	01/10/2004					2018
60	24/09/2007				09/06/2022	07/07/2022	09/06/2022	09/06/2025		17/05/2022
61	20/06/2005				09/06/2022	07/05/2019	09/06/2022	09/06/2025
62	18/02/2013				15/12/2020	11/01/2021	15/12/2020	15/12/2023
63	04/04/2005				28/09/2020	2020	28/09/2020	28/09/2023
64	16/08/2010				21/06/2022		21/06/2022	21/06/2025		08/06/2022
65	05/09/2022	06/09/2022		QMU			28/10/2022	28/10/2025
66	01/09/2016				12/01/2021	28/01/2021	12/01/2021	12/01/2024
67	01/04/2010				12/01/2021	20/01/2021	12/01/2021	12/01/2024
68	31/01/2005				23/01/2020	17/02/2020	23/01/2020	23/01/2023
69	01/10/2004				06/09/2018	25/09/2018	06/09/2018	06/09/2021
70	01/10/2014
71	09/09/2019				21/06/2022		21/06/2022	21/06/2025		20/06/2022
72					06/09/2018	26/09/2018	06/09/2018	06/09/2021
73	11/12/2017				12/05/2022	28/08/2018	12/05/2022	12/05/2025
74	15/09/2014				12/05/2022	18/02/2020	12/05/2022	12/05/2025
75	01/10/2004				27/02/2020	18/03/2020	27/02/2020	27/02/2023
76	05/09/2022	06/09/2022		QMU		2020	28/10/2022	28/10/2025
77	08/10/2007				24/09/2020	07/10/2020	24/09/2020	24/09/2023
78	01/07/2013					2020
79	05/09/2022	06/09/2022		QMU		un known	28/10/2022	28/10/2025
80	05/12/2022
WL HV

Cell Formulas
Range	Formula
H2:H6,H80,H77:H78,H66:H75,H31:H64,H17:H29,H8:H15	H2	=IFNA(IFS(D2>F2,D2,D2<F2,F2),"")
I2:I80	I2	=IF(H2="","",EDATE(H2,36))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I:I	Cell Value	between TODAY() and TODAY()+76	text	YES
I:I	Cell Value	<TODAY()	text	NO
J:L	Cell Value	between TODAY() and TODAY()+365	text	NO

Cells with Data Validation
Cell	Allow	Criteria
L1:L80	List	Completed, Not completed

 

[Fluff]

For H2 try

=IF(D2>=F2,D2,if(D2<F2,F2,""))

The formula in I2 should work in 2007

 

[joz110820]

For H2 try

=IF(D2>=F2,D2,if(D2<F2,F2,""))

The formula in I2 should work in 2007

That works although where there are blanks in both D2/F2 it is resulting in a "00/01/1900" would prefer for that to just be blank if possible. No worries if not possible, might be able to work around.

 

[joz110820]

That works although where there are blanks in both D2/F2 it is resulting in a "00/01/1900" would prefer for that to just be blank if possible. No worries if not possible, might be able to work around.

Gosh I was too excited to respond, I was rude and never said thank you for your help!

 

[Fluff]

As long as D & F will never have the same date, try

=IF(D2>F2,D2,IF(D2<F2,F2,""))

 

[joz110820]

As long as D & F will never have the same date, try

=IF(D2>F2,D2,IF(D2<F2,F2,""))

This has all worked beautifully and my colleague confirms that it works from her wyse machine too. Thank you SO much!!!

 

[Fluff]

You're welcome & thanks for the feedback.