Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


Continious day numbers and names through pages

New Here ,
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

84

Likes

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

Adobe Community Professional , 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

Likes

Translate

Translate
Adobe Community Professional ,
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

 

 

Likes

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
Adobe Community Professional ,
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

Likes

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
Adobe Community Professional ,
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

 

 

Likes

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
Adobe Community Professional ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

Schermata 2021-08-26 alle 09.02.02.png

Likes

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
Adobe Community Professional ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

Schermata 2021-08-26 alle 09.02.21.png

Likes

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
Adobe Community Professional ,
Aug 26, 2021 Aug 26, 2021

Copy link to clipboard

Copied

LATEST

Schermata 2021-08-26 alle 09.02.54.png

Likes

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