DATEDIF Summary column with blanks

[Aussie5380]

Hi there,

I was hoping someone may be able to shed some light on a little problem i have.

I have created a basic year/month/day calculator for work, but im having trouble totalling all the date range cells as a whole. This is the first time i've used the DATEDIF function, but it seems to do what i want it to. (please ignore the background lol its easier on the eyes while i tinker)

I have attached a pic of how it looks. I want to total all of the white cells on the left at the top where i can total the calendar days and work days. I have tried multiple SUM, SUMIF's, DATEDIF's and other formulas to total it at the top but i keep returning an error.

DATEDIF may also not be the best formula for what im trying to achieve? (im open to critical feedback)

My columns are C39:C58 (start date) E39:E58 (end date) and it will have blanks (towards the bottom) if not all fields are completed. Again, not sure if this is achievable?

Any assistance would be appreciated

 

[awoohaw]

I have some questions about what you're seeking.
Why do you want to sum dates?
I have tried to replicate your data here, but, I'm one day off in the total days for each row.
What function are you using for workdays? I am assuming you have Sat/Sun weekends and no holidays:

Book1
	A	B	C	D	E	F	G	H
1
2
3
4
5
6
7
8				Years	Months	Days	Cal Days	Work Days
9			Totals				468	335
10
11		From	to	Year/s	Month/s	Days/s	Cal Days	Work Days
12		2022-01-01	2022-12-31	0	11	31	364	260
13		2023-01-01	2023-04-15	0	3	15	104	75
14
Sheet1

Cell Formulas
Range	Formula
G9:H9	G9	=SUM(G12:G13)
D12:D13	D12	=DATEDIF(B12,C12,"y")
E12:E13	E12	=DATEDIF(B12,C12,"m")
F12:F13	F12	=DAY(C12)
G12:G13	G12	=C12-B12
H12:H13	H12	=NETWORKDAYS.INTL(B12,C12,1)