Hi Jon Let's say the subscription of 1,200 is for 3 months, renewable for the next 2 years, can you not put the start date and end date like this: ...
Hi Tony Give this a try. Select any cell in the column and run the macro. The formula will be inserted 2 rows below the last cell and will sum star...
I believe you clicked on the wrong axis. Click on the axis below your chart (not the one on the left)
Right click the axis Format Axis-Axis Option select Minimum Fixed and set to 0 and click OK
From the title of the post, it said recurring subscription revenue (i.e. revenue earned for each month) but the example given below looks like a reduc...
Dates are pretty tough to handle given the different formats (US/UK formats) and selecting them from a list is the best as mentioned by Philip. I n...
Hi CJ18 It was way pass midnight over here when I answered your post and I was already half asleep. Good to hear you have solved the problem. ...
Not pretty but should work =IF(AND(E7>=D3,K7=1),1,IF(OR(E7>$D$3,I7>$D$3),0,K7))
Neither of them have reached the anniversary date yet so they show 0 as what you have requested below. "So, the difficulty I'm having is that when ...
Hi Just let us know which cells are not correct and what are the expected results. It is very difficult for us to make a guess.
Sorry change to =IF(OR(E7>$D$3,I7>$D$3),0,K7)
Try this in column L =IF(OR(E7>$D$3,I7>=$D$3),0,K7)
Is column M as per your file your expected answer?
You are welcome
Hi, see if this is what you want. You will need to open both the Help and Inventory file. Click on the Import Data button and select which sheet...