Calculating the number of 15 min increments between two dates and weeks

[JosieJosie02]

I can't figure out what I am doing wrong, 2 different answers.

Can someone please help me?

I have a start date and end date, Hours/Per week, the number of weeks between the start and end dates, the number of months, and a total.

Number of days is calculated =DATEDIF(A2,B2,"D")

Number of weeks is calculated =WEEKNUM(D2)

Number of months is calculated =DATEDIF(A2,B2, "M")

Number of 15 min increments for number of days and weeks is calculated =(C2*4*E2)

A Start Date	B End Date	C Hours / Week	D Days	E Calc Weeks	F Months	G Unit Value	H Unit	I TOTAL
6/1/2022	5/31/2023	24	364	52	11	15	Minute	4992	correct hours/week but wrong total
6/1/2022	5/31/2023	23.079	364	52	11	15	Minute	4800	Correct total but with wrong hours per week

 

[Joe4]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculating the number of 15 min increments between two dates and weeks
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[SpillerBD]

DATEDIF "Calculates the number of days, months, or years between two dates."
364 Days exclusive or should that be 365 days?
Same question for Months.
Review your Units of measures through your calculations.