Free Notion Date & Time Formula Templates

1. Show Weekday (Mon)

Copy the formula:

formatDate(prop("Date"), "ddd")

2. Show Weekday (Monday)

Copy the formula:

formatDate(prop("Date"), "dddd")

3. Show Month (Jan)

Copy the formula:

formatDate(prop("Date"), "MMM")

4. Show Month (January)

Copy the formula:

formatDate(prop("Date"), "MMMM")

5. Show Year (2030)

Copy the formula:

formatDate(prop("Date"), "YYYY")

6. Show Week Number

Copy the formula:

formatDate(prop("Date"), "W")

‍

To display the label:

"Week " + formatDate(prop("Date"), "W")

7. Show Month Number

Copy the formula:

formatDate(prop("Date"), "M")

To display the label:

"Month " + formatDate(prop("Date"), "M")

8. Show Quarter Number

Copy the formula:

formatDate(prop("Date"), "Q")

To display the label:

"Quarter " + formatDate(prop("Date"), "Q")

9. Format Date (Mon, Jan 1st, 2030)

Copy the formula:

formatDate(prop("Date"), "ddd, MMM Do YYYY")

10. Format Date (Month/Date/Year)

Copy the formula:

formatDate(prop("Date"), "MM/DD/YYYY")

11. Format Date (Date-Month-Year)

Copy the formula:

formatDate(prop("Date"), "DD-MM-YYYY")

12. Show Month & Date

Copy the formula:

formatDate(prop("Date"), "MMM DD")

13. Show Month and Year

Copy the formula:

formatDate(prop("Date"), "MMM YYYY")

14. Show Current Date & Time

Copy the formula:

formatDate(now(), "ddd, MMM DD, YYYY HH:mm A")

15. Show Morning/Afternoon Based On Time

Copy the formula:

if(hour(prop("Date")) < 12, "Morning", if(hour(prop("Date")) < 17, "Afternoon", if(hour(prop("Date")) < 20, "Evening", "Night")))

16. Show Weekday Passed Percentage

Copy the formula:

format(round((toNumber(formatDate(prop("Date"), "d")) / 6) * 100)) + "%"

17. Show Current Weekday In a Week

Copy the formula:

if(formatDate(prop("Date"), "d") == "0", "<S> M T W T F S", if(formatDate(prop("Date"), "d") == "1", "S <M> T W T F S", if(formatDate(prop("Date"), "d") == "2", "S M <T> W T F S", if(formatDate(prop("Date"), "d") == "3", "S M T <W> T F S", if(formatDate(prop("Date"), "d") == "4", "S M T W <T> F S", if(formatDate(prop("Date"), "d") == "5", "S M T W T <F> S", "S M T W T F <S>"))))))

18. Show Early, Mid or Late Week

Copy the formula:

if(toNumber(formatDate(prop("Date"), "d")) <= 2, "Early Week", if(toNumber(formatDate(prop("Date"), "d")) <= 4, "Mid Week", "Late Week"))

19. Show Weekday or Weekend

If your Week Start Day is Sunday

if(toNumber(formatDate(prop("Date"), "d")) == 0 or toNumber(formatDate(prop("Date"), "d")) == 6, "[Weekend]", "Weekday")

If your Week Start Day is Monday

if(toNumber(formatDate(prop("Date"), "d")) == 5 or toNumber(formatDate(prop("Date"), "d")) == 6, "[Weekend]", "Weekday")