Help

Formula to Automatically Update Based on Months/Days

Topic Labels: Formulas
Solved
Jump to Solution
556 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: