simply formula by writing it in VBA

Hi there,

I have written a series of formulas in an excel workbook and need to consolidate the steps.

What the formulas do is look up the value in B1 and if the date in cell "A1" is less than the first Tuesday of the month, then this cell should have First Tuesday of the month else it should have the first Tuesday of the next month.

Currently this is part of a really big spreadsheet so I would prefer it to only be the vlookup and one other cell.

I have attached the spreadsheet and would be very grateful if someone could suggest either some vba code to simplify the process or help me create a nested formula to consolidate all the steps.

thanks