fiscal quarter data validation

[Doug Glancy]

Hello,

I need data validation in a cell that offers the end dates for the previous
4 fiscal quarters, e.g., for today:

September 31, 2004
December 31, 2004
March 31, 2005
June 30, 2005

What's the easiest way to do this? VBA or not, either is fine.

Thanks,

Doug

 

[Debra Dalgleish]

You could list the dates in an empty part of the workbook, and name the
range.
Then, in the data validation dialog box, choose to Allow List, and use
your named range as the source.

There are instructions in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

 

[Doug Glancy]

Thanks Debra,

I can do that. I can also add the formulas to make sure it's always the
most recent four quarters, I just wanted to make sure there wasn't some cool
way to do it right inside the D V dialog. Short of that, I'll probably just
do it with VBA.

Doug