#### Mark McInerney

##### Board Regular

- Joined
- Apr 4, 2012

- Messages
- 210

I am trying to build a tax calculator/forecasting tool. I need it to be relevant and up to date.

In summary Cell A1 is a date entry box. This is always my starting point.

There are a number of transactions that are linked to a quarterly and bi annual cycle and I cannot come up with a formula - driving me mad!

A typical example is: The VAT is due on the 23rd of every second month, starting in Jan and going thru Mar, May, Jul, Sep, Nov. So when I put 1/1/2012 in Cell A1 I need the Vat date to be 23/1/2012.When it is 5/10/2012 I need it to be the 23/11/2012.

I also have a quarterly billing problem. As above I put a date in Cell A1, and I need a formula that will give me the next 19th of the following months Mar, Jun, Sep and Dec. e.g. Cell A1 - 6/3/1978 - I need the output to be the 19/3/1978.

If you can help....I would appreciate some explanation as to the logic of the formula as I am sure I wil have to come up with more date formulas later.

As always appreciate your help on this one - Many Thanks - Mark.