Date Selector
 

I have data validation on a cell in a worksheet. It has a list with
yesterday, today, this month, last month, this quarter, last quarter, this
year, last year. How would i program that when one of these items is
selected the start date and end date are entered into two cells onto the
worksheet?

Date Selector
 

How do you determine the dates?


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39690

Date Selector
 

Check Out Chip Pearsons Web Site

http://www.cpearson.com/Excel/betternetworkdays.aspx

"Enyaw" wrote:

I have data validation on a cell in a worksheet. It has a list with
yesterday, today, this month, last month, this quarter, last quarter, this
year, last year. How would i program that when one of these items is
selected the start date and end date are entered into two cells onto the
worksheet?