If the developer tab is not already available in your Excel ribbons, you can follow these steps. This guide shows you a trick that might work for you and save you tons of your time.īefore we start, you have to make sure the developer tab is available. A drop down calendar allows your users to fill the dates on a click of mouse. It always confuses the people if they should be mm/dd/yy or dd/mm/yy or mm-dd-yyyy? Or can you type a date like “”? Oh, and what would be the date of the third Friday in October this year?Īdding a drop down calendar in your excel sheet can solve these problems.
Especially, entering dates can become a nasty work. It can be a headache to maintain the data integrity when you are working with bigger and shared Excel worksheets.
Have you ever wanted a calendar to show next years date? It’s easy and convenient in most of the cases.
0 kommentar(er)
