Inputting a column of dates manually is a tedious process that can result in inconsistent formats and erroneous values.
Therefore, it would make sense to use a date picker. Except, Excel does not have one natively - at least not in 64-bit versions. This means you're dependent on third-party add-ins.
There're a few out there, but a particularly good one is featured on a website called Rad Sheets.
Do the following:
1️⃣ Go to samradapps.com..., scroll down and select Download now.
2️⃣ Select Save as, and create a new folder in the C drive called 'XLStart'.
3️⃣ Save the ZIP file in that folder, copy the add-in file from within and paste it outside.
4️⃣ Delete the ZIP file.
5️⃣ In Excel, go to File ＞ Options ＞ Advanced, scroll down and find 'At startup, open all files in'. Specify the folder directory 'C:\XLStart' and select OK.
6️⃣ Close all instances of Excel and then reopen a window.
The date picker button now appears in the ribbon and as an icon beside the active cell if it uses the Date number format or is directly below a cell that contains a date.
Have a go and see what you think. Hopefully, we won't have to rely on third-party add-ins in the future, but it's the best we've got for now!
#exceleration #excel #microsoftexcel #excelformulas #exceltips #globalexcelsummit
---
The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts.
Learn more at globalexcelsum....
Find us on:
👔 LinkedIn: / global-excel-summit
🐤 Twitter: / excelsummit
🟦 Facebook: / globalexcelsummit
📸 Instagram: / globalexcelsummit
🤳 TikTok: / globalexcelsummit
5 окт 2024
