ATOI365D#Office365Challenge This formula allows you to calculate the day of the week for the date and returns the full name of the day.

Day: 279 of 365, 86 left
Tools: Office 365, SharePoint
Description: SharePoint Show dates as days of the week
Audience: All

Here’s another goody. Of course, only if you need something like this :-):

Should you have a date column in your library or list, you can add a calculated column to ‘strip’ out the day of the week. I’ve used the Modified column as an example:

041216001

 

This is the end result:

041216002

Voila!

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Advertisements