need help with DATEIF formula

[leopardhawk]

Hello forum friends, I have an issue with the results of a DATEIF formula I am trying to build. I am receiving a result of $161.92 and it should be $50.06, so I am WAY off somewhere. I have included snapshots of the cells in question below. If anyone has any ideas, I will be grateful.

Excel 2016 (Windows) 32 bit
	E
4	$ 7,910.23
5	$ 161.92
totals

Cell Formulas
Range	Formula
E5	=SUM(E4/DATEDIF('2018'!C2,'2018'!D2,"d")+DATEDIF('2019'!C2,'2019'!D2,"d"))

Excel 2016 (Windows) 32 bit
	C	D
2	01-Jan	29-Mar
2018

Excel 2016 (Windows) 32 bit
	C	D
2	05-Feb	17-Apr
2019

 

[MimiM]

Bracketing. If you want to divide what's in E4 by the sum of the two date differences, then the formula is

E4/(datedif(...) + datedif(...))

What your current formula is doing is dividing what's in E4 by the first DATEDIF result and then adding the second DATEDIF result

 

[leopardhawk]

sorry, I meant to say DATEDIF...

 

[leopardhawk]

Thank you so much! Works perfectly now.

Cheers!

 

[Peter_SSs]

@leopardhawk
What are you using to post you sample data? It is not displaying very well!

 

[leopardhawk]

Hi Peter, thank you so much for reaching out about this. It's called "Forum Tools" and I found the link to it on this forum. What's strange is that when I 'preview' the post, it looks perfect and then as soon as I submit the post, the results are not so good. It has worked a few times but I have no idea why it isn't consistent. I us the tool the same way every time. Also, I did reach out a while back to ask for any ideas and no one responded. If you know why this might be happening, I would love to hear back from you.

Cheers!

 

[Peter_SSs]

It's called "Forum Tools" and I found the link to it on this forum. .. If you know why this might be happening, I would love to hear back from you.

You may not be using the latest version. Follow the 'Look here' link in my signature block below & you will there find a link to the latest version. Make sure you read the N.B. points at the end of post 2 in that thread.

 

[leopardhawk]

Hi Peter, thank you so much for that. I'm at work now but as soon as I get home, I will certainly follow up and try to make sure that I have the latest version. Thanks again. Have a great day!

 

[leopardhawk]

Hi Peter, okay, I tried deleting the old file for Forum Tools and downloaded a new one (by the way, I have only been using the previous one since May of this year when I first downloaded it). Anyway, you can see in the 'Test' section that the results are the same. BTW, I am using Windows 10, Chrome browser, Excel 2016... Any ideas??

Cheers!