is there a function to fetch date values in excel using office script that will preserve the format?
main program objective : skim through a column of dates and identify the row of current date
Is it possible to edit office scripts for Excel on the web in VS Code and use git for source control?
I am using a Microsoft 365 work account and I want to develop Office Scripts for Excel to automate monthly Excel tasks that I can also share with other co-workers. Sharing a Script has been fine. But as I am developing the Scripts, I really want source control and to document the development process. I was hoping to use VS Code (either desktop or on the web version) to edit and version control (git) the script.