Difficulties with Dates...

[justdave3283]

Hi all,

I'm Dave, I'm new and I'm a complete Excel novice (think I'm probably being generous to myself there), so please be gentle...

Anyway, my problem:

I would like to create a dropdown list in one of my spreadsheets, which is easy enough. However, I would like for the user to be able to select one of four months (Apr, Jul, Oct, Jan), then to select a year (2014,2015,2016, etc).

I think this would be much more user friendly than having a dropdown list with options such as Oct 14, Jan 15, Apr 15, Jul 15, ad nauseum.

However, I'm completely stuck.

Any help would be gratefully accepted.


Thanks in advance
justdave

 

[justdave3283]

Apologies, i should have mentioned I'm working in Excel 13.

Thanks again

 

[hippiehacker]

so you want to create 2 drop down lists?

 

[Oeldere]

Reading your question, I believe you want to have 1 drop down list for all values.

In that case make a list with all values (okt.15 / jan15/april15 etc) and refer to that (drop down) list.

 

[hippiehacker]

@oeldere this is what he doesn't want

 

[Oeldere]

@hippiehacker

In that case he/she has to make 2 list and refer to 2 drop down list. (as you stated in #3).

But if I was the user of that file, I prefer my solution (with 1 drop down list).

 

[justdave3283]

so you want to create 2 drop down lists?

thanks for replying.

I guess I do, but I'd like the two options to populate to 1 cell.
(So the text shows as for example Jul-15, or Oct 17...)

I'd just rather the user was able to select from 4 months, then 4 years, rather than 16 options of month/year.

Hope that makes sense.

Dave

 

[hippiehacker]

assuming your drop downs are in Cell A1 and B2 you can combine the result in one cell like

=IF(OR(A1="";B1="");"";A1 & " - " & B1)