Date Formula

[FrankNotWalter]

Hello,

I am looking to write an formula that will work out how days are left until a certain date, 14 Sept 2023.

I have tried numerous times but can't quite get it to work.

past attempts:

DATE_DIFF(TODAY(), PARSE_DATE('2023-09-14'))

DATE_DIFF(DAY, CURRENT_DATE(), '2023-09-14', DAY)

The formula will be used to calculate the projected budget spend of a campaign, so I will using the average daily spend and multiplying by the number of days left of the campaign which ends on the 14 Sept 2023.

Any help would be greatly appreciated.