Forum Discussion
Microsoft Excel - Addin dates & Weekdays on a Excel reports
So im a night manager at a hotel. My shift starts late in the evening, and end early in the morning the next day. The first thing i fill out with the report is the dates. I already have the dates set...
Hi!
As per your first question, I believe you can simply and easily change the format of the cells containing the dates. You probably have the "short date" or a "custom" format. I think that you are looking for a "Long Date" format. Click on the cells containing the date, go to the Home tab, on number options, look for and click Long Date. It will automatically contain the weekday as well. If that is not the case, you could use some formulation too, but you will go well with just that.
As per your second question, I would use something like Power Automate. You can google some how-to's and I am sure you will be able to find something quickly.
Martin