Page 1
Page 1
Posted by
Message
Big Chipper
LSU Fan
Charlotte, NC
Member since Sep 2008
2061 posts

Excel Formula Help
Need someone to check my math on a simple year over year formula. The variable is the number of business days. So in cell c17 I have 20,000 and in c18 I have 25,000. This would be a straight 25% YoY change. But since I need to factor in the real change with business days (there were 104 business days YTD May 2017 and 105 YTD business days in 2018), I'm thinking the formula looks like this: =(SUM(C18-C17)/C17)*(1*(104/105)) and gives me a result of 24.8%. Is this right?

LSUtigerME
LSU Fan
Walker, LA
Member since Oct 2012
2044 posts

re: Excel Formula Help
How are you obtaining the “business days”?

If just weekdays, can use function “Networkdays” and just compare directly. This also allows you to exclude holidays, but that gets more complicated.

Big Chipper
LSU Fan
Charlotte, NC
Member since Sep 2008
2061 posts

re: Excel Formula Help
I already track the business days separately. Trying not to over complicate things here. I just need the 2017 and 2018 results to be apples to apples.

Replies (0)
Replies (0)
00
CubsFanBudMan
Chicago Cubs Fan
Member since Jul 2008
3644 posts

re: Excel Formula Help
Calculate the sales per day then the percent change:

=((25000/105)-(20000/104))/(20000/104)

23.8095%

Big Chipper
LSU Fan
Charlotte, NC
Member since Sep 2008
2061 posts

re: Excel Formula Help
Thanks...that makes more sense.

Replies (0)
Replies (0)
00
Page 1
Page 1 of 1

Follow TigerDroppings for LSU Football News