Validation

M

muddan madhu

Hi,

I have date like this
Column A Column B

Jun-2007 30 days
Aug-2007 31 days
Feb-2008 29 days

I used data validation for Column A
If I choose Jun-2007 in the column B I need only June date like
01-jun-07, 02-jun-07 .....................30-jun-07
Similarly for others.

I don't want to create separate date list for jun,jul..... And then use
=indirect function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to avergage colums 7
How to determine the value? 2
Allocation/Distributiona Formula... 0
Count Dates in a range based on Column Header Id without using sum-product 1
Mixed Data in column 5
Reverse Index Match 2
Show a date based on another date 1
Formula to fill cells based on Date of Arrival and Date of Departure 1

Top