We have an excel report which looks at active orders and arranges them as a timeline according to the date in which they are due to be completed. The timeline shows all jobs due to be completed in a "week commencing" which SHOULD always begin on a Monday.
I am able to show weeks from today by inserting '=today()' in H5, then by using '=h5+7' to get following week commencing date.
The problem with this is that i have to run the report on Monday for all the Week commencing dates to be mondays.
How can i find the date of the Monday previous to today?
Hope that makes sense!
Risking that Kris is typing at the same moment as I am now, still an answer:
gives the date of last Sunday. It is the day of today, minus 1 if we are on a Monday, 2 if on a Tuesday, ..., till 7 for a Sunday. The 2 as the last argument refers to whether weeks start on a Monday or a Sunday.
Knowing the date of Sunday, we do +1 and have the date for Monday.
There are currently 3 users browsing this thread. (0 members and 3 guests)