Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to Automatically Update Based on Months/Days

Topic Labels: Formulas
Solved
Jump to Solution
1148 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucie_Tennis
4 - Data Explorer
4 - Data Explorer

Hi everyone,
I have a fairly complex base tracking financials, burn rate, and runway. I have run into a snag trying to come up with a formula that will automatically update based on what month of the FY we are in (for burn rate). For example, I have a table specifically for burn rate. If I want to see our burn rate YTD, I have to manually update the formula with the current month (burn rate = (starting balance-ending balance/# of months)). Starting balance - ending balance is an easy part but currently I need to manually update the divisor (our FY is from Jan to Dec, so right now I am dividing it by 8.5). How can I get it to update automatically?
Can anyone help?

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

Hi @Lucie_Tennis,
You can get the current month with:

MONTH(TODAY())

Then it looks like you are taking the day of the month and dividing by 30 so you might want the following

MONTH(TODAY())+DAY(TODAY())/30

Which will give you 8.5 as of today August 15

See Solution in Thread

2 Replies 2
Vivid-Squid
11 - Venus
11 - Venus

Hi @Lucie_Tennis,
You can get the current month with:

MONTH(TODAY())

Then it looks like you are taking the day of the month and dividing by 30 so you might want the following

MONTH(TODAY())+DAY(TODAY())/30

Which will give you 8.5 as of today August 15

Lucie_Tennis
4 - Data Explorer
4 - Data Explorer

@Vivid-Squid THANK YOU!!! That did it :blush: