Hello,
I need a formula that will only look at the first week of the month. If the date is not the first week, then return a blank.
Let’s use 08/01/2013 for an example:
For the week of 08/01/2013, Sunday is the beginning of the week which is 07/28/2013 and Saturday is the end of the week which is 08/03/2013. I need a formula that will tell me, where the first lies in the particular weekday. If the 1st of the month shows up on a Thursday or Friday, then I want the formula to return “Next Week”. If the 1st of the month falls on a Monday, Tuesday, or a Wednesday, then I want the formula to return “This Week”. Please let me know if you need any clarification.
Thanks!
Bookmarks