Hi
I need help having an automatic week commencing date (from Monday) in cell A1
The date needs to be correct each time the workbook is opened.
Let me know if you need any more info.
Thanks for your help
Hi
I need help having an automatic week commencing date (from Monday) in cell A1
The date needs to be correct each time the workbook is opened.
Let me know if you need any more info.
Thanks for your help
In A1 enter =TODAY()-WEEKDAY(TODAY(),2)+1 to obtain first Monday of current week
Thanks. working now
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks