## [Solved] Calendar Template, Day of year and days remaining

Discuss the spreadsheet application

### [Solved] Calendar Template, Day of year and days remaining

Has anyone developed a calendar template for a year at a glance that includes the Date

Years ago I found one similar to this one that will create a year at a glance for any year
Any Year Calendar with Holidays
https://templates.openoffice.org/en/tem ... r-holidays

However someone in my group would like to see the number of the day in the year and days left, for example January one is day 1 with 364 days left
or December 4th is the 338th day with 27 days left (338/027)

Attached an image that shows an older calendar they used and would like to match.
Attachments
Last edited by Hagar Delest on Tue Dec 04, 2018 8:57 am, edited 1 time in total.
Reason: tagged solved
Apache OpenOffice 4.1.6
sheridangis

Posts: 3
Joined: Fri Nov 30, 2018 7:58 pm

### Re: Calendar Template, Days, Day of year and days remaining

sheridangis wrote:Years ago I found one similar to this one that will create a year at a glance for any year Any Year Calendar with Holidays. However someone in my group would like to see the number of the day in the year and days left, for example January one is day 1 with 364 days left or December 4th is the 338th day with 27 days left (338/027)
Just add day Number/Remaining as "holidays" on the last sheet.

Use Insert → Names → Define to assign \$Holidays.\$B\$3:\$B\$368 to Holidays. Enable Show Holidays in the Settings sheet. Use these formulas in row 3 of the Holidays sheet, then fill the formulas down.
«B3» =ROW()-2&"/"&DAYSINYEAR(calendarYear)-ROW()+2
«C3» ="Day "&ROW()-2
«D3» =DATE(calendarYear;1;ROW()-2)

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).

MrProgrammer
Moderator

Posts: 3964
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

### Re: Calendar Template, Days, Day of year and days remaining

Thank you for the info, this appears to insert the 1/364 and so on onto the monthly calendars and this is good. What I am hoping to find is a year at a glance calendar (all 12 months on one page) where we can have the Date at the top of the cell and under it the Day#/DaysLeft# in the same "box" as it were.
The jpg was just a screen shot of a 12 month calendar to show what each box would look like.
Apache OpenOffice 4.1.6
sheridangis

Posts: 3
Joined: Fri Nov 30, 2018 7:58 pm

### Re: Calendar Template, Days, Day of year and days remaining

Calendar1.ods
(32.39 KiB) Downloaded 24 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 28551
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Calendar Template, Days, Day of year and days remaining

Thank you
Apache OpenOffice 4.1.6
sheridangis

Posts: 3
Joined: Fri Nov 30, 2018 7:58 pm

Return to Calc

### Who is online

Users browsing this forum: No registered users and 11 guests