https://vbahowto.com
In this video you'll find out how you can use the Immediate window in the VBA editor to test out your functions.
I am showing you how to get the text day of the week from an actual date using the "format" function
I'm just showing you basically how to use it, but this is a little part of your whole project.
If you like the video, please share and like the video.
Let me know if you have any questions.
Thanks