Excel calendar

Mabocat

Board Regular
Joined
Apr 20, 2011
Messages
74
I am using this Excel calendar
https://support.office.com/en-us/ar...emplates-F2E7FFE9-41FA-4CE5-8278-CF92D3B66340
and while it seems OK, it is a pity that info added to specific dates is not copied through to same dates when modifying the year and saving it as a new year

for instance I add a birthday for 2018 to say Oct 8 which in 2018 is a Monday but just changing the year date for 2019, the info stays on a Monday which is the 7th.

It seems the info is not tied to a date but just relates the cell for the info.

Is there a way to fix this so this info is tied to a number which represents a date?

Thanks in advance
Ron
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Forget my question as it is not suitable to copy from one to to another without a LOT of work. Some events are date conscious and others are like every other Monday is the same activity.

Outlook calendar is perfect but I was looking at a way to be able to remove Office 2007 & just use Libre Office.



Ron
 
Upvote 0

Forum statistics

Threads
1,223,898
Messages
6,175,272
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top