Spend by Month - WORKDAYS works but DAYS doesn't

Platform discussions
, ,
1

I have a marketing budget and a campaign timeline. I am trying to build columns to show how much spend will run in each month by taking the total # of days in the timeline/flight and spreading that evenly over the # of days in the timeline/flight. This formula works when using WORKDAYS, however I need it to calculate against all days, but just switching WORKDAYS to DAYS is causing negative values.

WORKDAYS FORMULA
ROUND(DIVIDE({Budget},WORKDAYS({Flight#End},{Flight#Start}))*

ROUND(IF({Flight#Start}=“”,0,
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start}) <=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})>=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(WORKDAYS(“January 31 2024”,“January 01 2024”))),
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start}) >=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})<=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(WORKDAYS({Flight#End},{Flight#Start}))),
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start})<=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})<=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(WORKDAYS({Flight#End},“January 01 2024”))),
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start})>=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})>=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(WORKDAYS(“January 31 2024”,{Flight#Start}))),“”))))),0),2)

DAYS FORMULA
ROUND(DIVIDE({Budget},DAYS({Flight#End},{Flight#Start}))*

ROUND(IF({Flight#Start}=“”,0,
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start}) <=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})>=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(DAYS(“January 31 2024”,“January 01 2024”))),
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start}) >=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})<=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(DAYS({Flight#End},{Flight#Start}))),
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start})<=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})<=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(DAYS({Flight#End},“January 01 2024”))),
IF(
AND(
{Flight#Start}<>“”,
DATEVALUE({Flight#Start})>=
DATEVALUE(“01/01/2024”),
DATEVALUE({Flight#End})>=
DATEVALUE(“01/31/2024”)
),IF({Flight#Start}=“”,0,(DAYS(“January 31 2024”,{Flight#Start}))),“”))))),0),2)

Any thoughts as to why that small change would give a different output?