LinkBack URL
About LinkBacks
Good afternoon,
Could someone please help me with formulae that will "refresh" the days in a dropdown list (evaluation), as the months change. Only the days for the current month must display in the drop down menus. Thank you very much..
Good afternoon,
Could someone please help me with formulae that will "refresh" the days in a dropdown list (evaluation), as the months change. Only the days for the current month must display in the drop down menus. Thank you very much..
1 way could be to create a list of current month in a column(let's say B) using these formulas.
In B1
Formula:
=EOMONTH(TODAY(),-1)+1
In B2 and copy down until to see blank cell plus(+)1 blank cell.
Formula:=IFERROR(IF(B1+1>EOMONTH(TODAY(),0),"",B1+1),"")
Use this list for your data validation.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Sweet!!..thank you Fotis1991
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks