|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Date functions (TEXT(MONTH())) and TODAY()

Begär demo

We have encountered with few use cases:

1)Function Text + Month is not working as expected, as per below I would expect to receive value as "DEC", however final result is "Jan". Tried to modify MONTH value bus the outcome still the same "Jan"

2) Is there any timeline when Workiva will have TODAY() function?

0

Kommentarer

1 kommentar

Datum Röster
  • Isabel Messore
    • Redigerad

    Hi there Lukas Rakickas, 

    I don't believe you need the "MONTH". I'd recommend using the following:

     =TEXT('Entity Details'!$B$8, "MMM")
    • If you want it all caps (DEC), wrap it in UPPER: =UPPER(TEXT('Entity Details'!$B$8, "MMM")).
    • If you want "December," use four Ms: "MMMM".
    • Ensure the source cell (B8) is actually formatted as a Date in the Formats panel. If B8 is just "Text" that looks like a date, the TEXT() function might return an error.

    Let me know if this works for you or if you run into any issues!

    In regards to the TODAY formula, we introduced a lot of new formulas/functions in 2026. Unfortunately, the TODAY formula is not currently on our near-term roadmap. We do have a feature request in place that I can absolutely add you to. Should the TODAY formula be picked up for work, we would send an automatic update letting you know!
    0

Du måste logga in om du vill lämna en kommentar.