Drop down list

[jimboayr]

Hi Guys,

Looking for a formula that will give me a drop down list, for day, date, month, year.

As an example the start date would be Sat 20th Aug 2012.
Followed by Sun 21st Aug 2012 ect.

Jim

 

[jeffreybrown]

Hi Jim,

In a cell put 20 Aug 2012 >> Ctrl + Enter

Now format the cell as >> ddd d-mmm-yy

Now drag down using the fill handle and then add to your drop down as a list.