December 20, 2019
October 5, 2010
doing something like this is certainly feasible. You mention coding but I don't think VBA is required, you can just use functions.
If you look at the Resources menu at the top of the site and then go to Time and dates in excel, you'll find links to several posts on how to work with time/dates in Excel.