fiscal quarter data validation
 

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

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 he

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

Doug Glancy wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote in message
...
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 he

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

Doug Glancy wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html