Hey Everyone,
I was wondering if anyone knew how to make a range of dates for comparison that would take todays date, and then make the range the start date of the week through two weeks out?
I'm looking to make something that will search a column, if there are dates in the column I would like it to pull the date and compare it to a two week window. so say it is Thursday, they want the window to begin the Monday that had just passed and run two weeks from that date.
If there is a date in the cell in the column, and if that date falls into the two week window, then the cell would get highlighted.
Im not sure how to use the DAte (), NOW(), or DATEADD() feature to find the start of the week and work outward.
why cant they just want the current date forward
Any help would be appreciated
...
Bookmarks