Current week & previous week
I have a sheet with start date and finish date columns and a column to insert current/previous or blank (if the dates are neither current or previous weeks), so was thinking the formula would be something like if today's date is greater than or equal to the start date or less than or equal to the finish date insert "Current", but if its from the previous week insert "Previous", if it is neither current nor previous leave it blank.
Where do I go with this one?
Help Article Resources
Check out the Formula Handbook template!