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

Discuss the spreadsheet application

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

Postby sheridangis » Fri Nov 30, 2018 8:14 pm

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
Date_DayOfYearDaysRemaining.JPG
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

Postby MrProgrammer » Sat Dec 01, 2018 8:01 pm

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
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3809
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

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

Postby sheridangis » Mon Dec 03, 2018 11:31 pm

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

Postby Villeroy » Tue Dec 04, 2018 1:59 am

Calendar1.ods
(32.39 KiB) Downloaded 18 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.x
User avatar
Villeroy
Volunteer
 
Posts: 27090
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby sheridangis » Tue Dec 04, 2018 2:24 am

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 32 guests