Help with Formula - MMM-YYYY - Week of month


#1

Hey Guys, I am reaching out to all the Airtable Ninjas out there for some formula help. The end outcome that I am looking at achieving is ‘Month-Year - Week of month’. e.g. ‘Nov-2018 - W1’.

Here is my formula.

DATETIME_FORMAT({SCHEDULED DATE},‘MMM’) & “-” & DATETIME_FORMAT({SCHEDULED DATE},‘YYYY’) & " - W" & VALUE(DATETIME_FORMAT({SCHEDULED DATE},‘w’))- VALUE(DATETIME_FORMAT(DATETIME_PARSE(‘01’&DATETIME_FORMAT({SCHEDULED DATE},‘MM’)&YEAR({SCHEDULED DATE}),‘DDMMYYYY’),‘w’))+1

It throws a ‘NaN’ error message.