Month: July 2022

VALUE() of LEFT()

I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes...

Schedule column

Create list of dates excluding weekends and holidays.Basically create list of workdays in a certain year, you may fill in to get more. List of...