Dropdown List Containing dd/mm/yyyy

[rodcarv]

Hello,
I'm building a Work Hours Report spreadsheet to my co-workers but got stuck when creating a drop down list containing the following info: dd/mm/yyyy. I can certainly create it by putting all days of the year and creating the list attached to cells I want to show that up. But that would be too much info when someone needed to select the date.
In C2 of my spreadsheet, there's the Month Text info and if you change it, the month days will automatically change below. That's exactly I want to do with that Date Drop Down list. When I change the Month on C2, I want that drop-down list to show up only the dates of that month and not the whole year.

Is that possible?
I've attached the spreadsheet. The column i would like to have the drop-down list is P.

Thank you!!

[K m]

Yes, it is possible

In cell A42 enter this formula:
=IF(MONTH(C2)=2,"",A41+1)

In cell A43 enter this formula:
=IF(MONTH(C2)=2,"",A42+1)

In cell A44 enter this formula:
=IF(OR(MONTH(C2)=2,MONTH(C2)=4,MONTH(C2)=6,MONTH(C2)=9,MONTH(C2)=11),"",(A43+1))


See attached

[rodcarv]

Hello,
Thanks!! But I don't it's exactly I'm looking for. What I could understand from your formula is that you adjusted the number of the days that would show up when I select the month in C2, which is really great as well!
However, I'm more focused on creating the dropdown list in column P (Data Column). I would like that drop down list to show up the days (including dd/mm/yyyy) but not all year days. I would like to drop-down list to be linked with C2. So when I change C2 from March to April for example, the drop-down list in Column P would show up only the April Days and so on.

MANY THANKS!

[K m]

Sorry, I don't understand. Perhaps others can help

[rodcarv]

No problem. You don't understand what I mean ? or just don't know how to do it? Maybe I can clarify a little bit. Thank you!!

[K m]

If I understood your problem, I probable could help you

[rodcarv]

Well, basically what I need is just a Drop-Down list created in Column "P" linked to C2. So when I change the Month on C2, the drop-down list, created in Column P, would show up the days of that month selected in C2.
Thanks!!

[K m]

Couldn't you enter a data validation list with this criteria?

=$A$14:$A$44

See Attached:

By the way, I corrected errors in the formulas in column Q

[rodcarv]

I could. But according to labor laws, the Date should not contain only Ex: 12, 13. It must have the whole info: dd/mm/yyyy (That's why the drop-down list gets a little bit complicated). Not even sure if it's possible tho.

[rodcarv]

I mean our local labor laws.

[K m]

Try this spreadsheet

[K m]

I made an error. Try this:

[rodcarv]

We're almost there. However, if you select a random day on the spreadsheet it still shows 02/02/2013. Do you know how to fix it?

[rodcarv]

That's perfect!! What did you do??

[FDibbins]

Hi Rodcarv and welcoem to the forum

Not sure if this is something you can work with, but give it a shot. In the cell where you want the DD, select DD/list, and then enter...
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31

[K m]

I put in a custom format

[rodcarv]

Hi FDibbins, KM just fixed!!
I'm waiting on his reply to show me what he has done!!!

Thanks!!

[FDibbins]

yes, I saw that after I posted

[rodcarv]

Thanks everyone!! You guys are amazing!

[K m]

If the answer was helpful, click on the star at the bottom of this message

[FDibbins]

@ K M, not sure if you saw this post?

Hi FDibbins, KM just fixed!!
I'm waiting on his reply to show me what he has done!!!
Thanks!!

[K m]

I used a custom cell format to show the dates