Skip to main content
C
cemc18303069
Inspiring
August 24, 2021
Answered

Continious day numbers and names through pages

  • August 24, 2021
  • 6 replies
  • 519 views

Hello,

I am working on a planner and I want to add contininous day numbers with day names for each monthly pages like this. Is there a formula for doing this automatically?

Thank you. 

This topic has been closed for replies.
Correct answer vladan saveljic

in excel:

select column > go to "Format Cells" > Custom

Then insert this string

g gggg mmmm aaaa

 

Insert in "A1" 1-1-2022 end click enter

Select A1 and command drag (mac) until 365 row

 

 

6 replies

vladan saveljic
vladan saveljic
Inspiring
August 26, 2021

    vladan saveljic
    vladan saveljic
    Inspiring
    August 26, 2021

    vladan saveljic
    vladan saveljic
    Inspiring
    August 26, 2021

    vladan saveljic
    vladan saveljicCorrect answer
    Inspiring
    August 26, 2021

    in excel:

    select column > go to "Format Cells" > Custom

    Then insert this string

    g gggg mmmm aaaa

     

    Insert in "A1" 1-1-2022 end click enter

    Select A1 and command drag (mac) until 365 row

     

     

    vladan saveljic
    vladan saveljic
    Inspiring
    August 26, 2021

    If you want to insert all 365 days of the year you could create the list in Excel and place the list in the threaded text frames

    E
    Community Expert
    Eugene TysonCommunity Expert
    Community Expert
    August 26, 2021

    Unfortunately not - but if I'm not  mistaken it's just 12 manual inserts. 

    If I'm not mistaken 1st of January 2022 is a Saturday.

    1 Saturday January 2022

    1 Tuesday February 2022

    1 Tuesday March 2022

    1 Friday April 2022

     

    And so on

     

     

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices