Hi all,

I am new to the forum so apologies if this is in the wrong section.

I am working with some data for power vs time. The data is taken from a data logger which outputs values every five minutes so there is quite a bit of data.
I am looking to use the drop down lists to allow someone to pick: the year, the month & the day. From that I want to be able to do a vlookup of my data with the times chosen.

The data itself outputs time & date as :"dd/mm/yyyy hh:mm:ss" (which is a pain in the ar*e). The problem I am having is I can't get the three separate drop down boxes (i.e. year, month, date) to combine into the correct format (i.e. dd/mm/yyyy) so I can do a vlookup on it. Any suggestions?