I'm trying to come up with a TRUE/FALSE formula to check if a date is within last week. I thought this would be quite simple but that's not the case (at least for me).
I have come up with a formula that checks if today's date is within the current week and year - and that works perfectly fine using WEEKNUM and YEAR. I thought I might be able to use WEEKNUM -1 or something similar but that's doesn't seem possible when you are at the start or end of the year.
My week starts on a Monday and the year must also be taking into consideration.
I hope you can help.
I have come up with a formula that checks if today's date is within the current week and year - and that works perfectly fine using WEEKNUM and YEAR. I thought I might be able to use WEEKNUM -1 or something similar but that's doesn't seem possible when you are at the start or end of the year.
My week starts on a Monday and the year must also be taking into consideration.
I hope you can help.
