Due Date is this week or next week forumula

[Adam_Zeis]

I’m trying to come up with a formula to denote if something is due “This Week” or “Next Week” but can’t seem to nail it down. I’ve tried using this:

IF((WEEKNUM({Due Date}, IS_SAME(WEEKNUM(TODAY()))))

Airtable accepts the formula, but I get an #ERROR in the field. I’m just looking for it simply to return a “1” or “0”. I also need to denote Next Week in another field, which I was planning to build off this formula if I got it working. Any help is appreciated.

[Howard_Wood]

I took your spaces out ( is that correct)

& changed my description but it is saying formula incorrect

IF(DATETIME_DIFF({Date Next Visit Confirmed},TODAY(),‘days’)<=7,“check”)

Kind Regards,

Howard Wood

[Howard_Wood]

wont reply by email again!!

[Jeremy_Oglesby]

Spacing doesn’t matter in Airtable’s formula builder.

Looking at that again, though, I think it needs to be ‘<= -7’ rather than positive 7.

And regarding the error, try manually typing the formula into the formula builder — it may be a problem with “smart quotes”

[Howard_Wood]

TOOK A BIT OF EXPERIMENTING BUT FINALLY MANAGED IT THANKS
tHIS WORKS

IF((DATETIME_DIFF({Date Next Visit Confirmed},TODAY(),‘days’))<-7,“CHECK”,“OK”)