Description :

The date for monday and friday of the current week can be determined as illustrated below select getdate 2 datepartweekday getdate as mondaygetdate 6 datepartweekday getdate as friday this assumes that you consider the first day of the week to be a sunday and that the last day of the week is a saturday. Thanks for dropping by my mission is to make you awesome in excel your work i live in wellington new zealand when i am not f9ing my formulas i cycle cook or play lego with my kids know more about me i hope you enjoyed this article visit excel for beginner or advanced excel pages to learn more or join my online video class to master . Robusto i can see that it may seem that i was commenting on your comment i was not i was pointing out that the op already had a formulation that was grammatical etc except for the odd locution from monday friday thank you for the opportunity to clarify what i was addressing jeff morrow mar 20 18 at 2050. Its happened before for example in 2007 the us state of utah redefined the working week for state employees with extended hours on monday to thursday meaning it could eliminate fridays entirely. You have encountered one of the worst examples of ambiguity of meaning in english to my knowledge there is no standard defining what each term really means in every case i can think of when someone says this friday or next friday i have h