Page 1 of 1

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

PostPosted: Fri Nov 30, 2018 8:14 pm
by sheridangis
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.

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

PostPosted: Sat Dec 01, 2018 8:01 pm
by MrProgrammer
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.
Screen Shot 2018-12-01 at 11.45.47 .png

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

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

PostPosted: Mon Dec 03, 2018 11:31 pm
by sheridangis
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.

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

PostPosted: Tue Dec 04, 2018 1:59 am
by Villeroy
Calendar1.ods
(32.39 KiB) Downloaded 18 times

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

PostPosted: Tue Dec 04, 2018 2:24 am
by sheridangis
Thank you