• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Continious day numbers and names through pages

Explorer ,
Aug 24, 2021 Aug 24, 2021

Copy link to clipboard

Copied

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. 

mondayjpg.jpg

TOPICS
How to

Views

274

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Guide , Aug 26, 2021 Aug 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

 

 

Votes

Translate

Translate
Community Expert ,
Aug 25, 2021 Aug 25, 2021

Copy link to clipboard

Copied

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

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

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

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

Schermata 2021-08-26 alle 09.02.02.png

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

Schermata 2021-08-26 alle 09.02.21.png

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

LATEST

Schermata 2021-08-26 alle 09.02.54.png

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines