Is it possible to have a control to pop up a date "Month" selection box from
clicking on the cell?
I would click on the Month Cell, the calander for the month appears, I make
my day selection and the date appears in the next cell as mm/dd/yy.
Is it possible to have a control to pop up a date "Month" selection box from
clicking on the cell?
I would click on the Month Cell, the calander for the month appears, I make
my day selection and the date appears in the next cell as mm/dd/yy.
Just create a list, in say M1:M31, of
=IF(ROW(M1)<=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)),ROW(M1),"")
and in Data Validation, add a list formula of
=OFFSET($M$1,,,COUNTA($M:$M),1)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Kane" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to have a control to pop up a date "Month" selection box
from
> clicking on the cell?
> I would click on the Month Cell, the calander for the month appears, I
make
> my day selection and the date appears in the next cell as mm/dd/yy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks