Skip to main content

Help with Formula - MMM-YYYY - Week of month

  • November 8, 2018
  • 0 replies
  • 3 views
G

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.

    This topic has been closed for replies.
    Terms & ConditionsAccessibility statement