Hello![]()
I have a yearly calendar in Excel and I want to change the starting day of the week from Sunday to Monday, and I don't know how to do that because it has so many formulas![]()
Can anyone help me please ? ?Thanks
Hello![]()
I have a yearly calendar in Excel and I want to change the starting day of the week from Sunday to Monday, and I don't know how to do that because it has so many formulas![]()
Can anyone help me please ? ?Thanks
Given the setup I think you just need to
a) modify the WEEKDAY function to use return type of 2 (Monday = Day 1)
b) modify the weekly headers accordingly (such that duminică is last etc..)
See attached:
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thank you thank you thank you![]()
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks