Data Validation - Month List

[amitwaze]

Hi,

I am trying to keep the current month as active in my drop down list every time i open the sheet so that it should show the data only for the current month based on the current month.

Can anyone please help me with this.

I have this drop down list in A1.(Jul, Aug, Sep, Oct .. so on)

I am looking for some formula for this and not a VBA code.

Thanks

Regards,
Amit

 

[Excelestial]

A little more detail, please. Are you the only one using the spreadsheet...or are multiple people using the dropdown?

If you want the spreadsheet to always use the current month, why not replace the dropdown with the simple formula =text(today(),"Mmmmm")...or whatever your dating convention is?

 

[amitwaze]

yes i am the only on using the sheet.

The reason i need the drop down so that if i want to see the data for the previous month i can do that by just changing the month in the drop down list.

I hope i am clear.

Regards,
Amit

 

[amitwaze]

can anyone please help me on this.

 

[cbiscione]

can anyone please help me on this.

Maybe this response is a little late, but anyways, i had the same problem and solved generating a validation list like this:
[TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"][TABLE="width: 173"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]0[/TD]
[TD] March, 2018[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD] April, 2018[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD] May, 2018[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD] June, 2018[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD] July, 2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Where the index number is in the cell to the left of the generated value and the formula to generate the list is:
=TEXT(TODAY()+(365/12*AQ3),"Mmmmmm, YYYY")
Being AQ3 the cell where the index for the first calculation (March, 2018) starts.
You then may use this formula to generate a longer validation list as you need. I did it for the next 36 months. You may start it one or several months before the current date (today) by starting your index in a negative integer value (For example for three months before today, you start with (-3) instead of zero).