Differences in two date sets calculated in one cell

[Stef9910]

Hello all,

Hopefully this mini sheet will work!!

Ok, so I am try to get H2 to display the span if F2 had a date it and D2 and E2 did not
So H2 is to display E2-C2 or if they are empty, display F2-C2
If H2 displays F2-C2, I would like G2 and I2 to display 0

Any help would be greatly appreciated,

Thank you

Stefan

Differnces between dates.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1			received	start	End	RTP	Days Until Started	Span	time taken
2			23-Mar-23	2-Apr-23	16-Apr-23		10	24	14
3
4
5			I am try to get H2 to display the span if F2 had a date it and D2 and E2 did not
6			So H2 is to display E2-C2 or if they are empty, display F2-C2
7			If H2 displays F2-C2, I would like G2 and I2 to display 0
8
Sheet1

Cell Formulas
Range	Formula
G2	G2	=SUM(D2-C2)
H2	H2	=SUM(E2-C2)
I2	I2	=SUM(E2-D2)

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1			received	start	End	RTP	Days Until Started	Span	time taken
2			23/03/2023	02/04/2023	16/04/2023		10	24	14
Main

Cell Formulas
Range	Formula
G2	G2	=IF(F2="",D2-C2,0)
H2	H2	=IF(F2<>"",F2,E2)-C2
I2	I2	=IF(F2="",E2-D2,0)

 

[Stef9910]

Thank very much Fluff, worked brilliantly

 

[Fluff]

You're welcome & thanks for the feedback.