How do i input the last day of the current quarter into cell B1? However, if
the date within cell A1 is within the current quarter then enter the last day
of the next quarter into cell B1. If the date in cell A1 is not at a minumum
of the previous quarter (two quarters ago), then I require a conditional
format to turn cell A1 red.