This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I want to write a formula for QTD calculations. Essentially I want every month that has passed in the quarter to have a 1 next to it and every month that is remaining to have a zero.
A1 will mention the current month. For this example lets say May, although it's actually April.
So I want Jan, Feb, and Mar to have 0 next to them (since they're not in this quarter). I'd like Apr and May to have a 1 next to them (since they're both in this quarter and have elapsed. And then all the other months after to say 0.
How can I do this?
Desired Output:
| Curr Mth | May |
|---|---|
| Jan | 0 |
| Feb | 0 |
| Mar | 0 |
| Apr | 1 |
| May | 1 |
| Jun | 0 |
| Jul | 0 |
| Aug | 0 |
| Sep | 0 |
| Oct | 0 |
Subreddit
Post Details
- Posted
- 8 months ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...