For the record, I did already try wrapping the date in a DATETIME_FORMAT which also gave a flat blank cell. Some issue with the way I am using WEEKDAY. Any ideas???
Page 1 / 1
Welcome to the Airtable community!
Writing complex formulas can be a bit of an art.
Your formula returns a string that looks like a date, not a date object. However the WEEKDAY function needs a date object, not a string.
I suggest a different approach using DATETIME_FORMAT to get the day of the week, and using the DAY to find out which week it is.
Thank you! This did work and I will mark it as the solution, however do you have any ideas why my formula returned a blank value instead of a #ERROR? As I mentioned, I did try wrapping the date object in DATETIME_FORMAT, so the formula looked like this:
Thank you for your help, it worked great. Just wondering what causes this issue because the logic looks fine to me? Especially a blank cell instead of throwing an error is very odd