Thanks for uploading a very very useful calendar in Excel. I appreciate your innovative skill. Please upload some more useful user friendly techniques. I am very much interested to learn more from your time saving videos. Hope you will upload.
Hi Trevor, thanks for your detailed instruction. In Cells E3 (End date), I tried formula '=EOMONTH(D3,0)' that returns the same result as yours. So we don't have to calculate the number of date in the month then calculate the last day of the month.
i have one questions like, i have predefined table(every month) which is we manually enter Calender Week as per the month, ( for ex:- this july 2018 -> cw 27, cw 28, cw 29, cw 30, cw 31..) , for this i want to do some automation in userform as well in Excel sheet also,, is there any method is there ? please help me if you come across or done before ?
sir i had stuck in confusion. if suppose we select cell A1 =now() and cell B1 given time 18:00 how can set to minus all time A1 is now time is 06:00am and how can countdown this values? after complete time msg come to what i written in Cell C1 Like "Your countdown complete" is written in cell C1. one more thing and auto every second minus to my value what i written B1 cell.
How do you get the event you input into a particular date to not replicate to all other dates in the calendar?example; if you write a note on January 15th, when you change to March the note is still in the cell you wrote it in even though the dates change. Any help would be great. Thanks
Hi Trevor First of all great calendar!! I hope that you can help me though, I have downloaded your calendar template but I am stuck on the cell D3; with this formula entered =DATE(E6,MATCH(C6,Months,0),1)-WEEKDAY(DATE(E6,MATCH(C6,Months,0),1),2)+1 it gives me error #NAME? What can I do to make it work? thank you for your time Simona
Hi Simona, I had the same problem. Make sure that you create a named range called "Months" with every month in a calendar year. Then you format the cell for the month pull down menu to the named range "Months" in the DATA>Data Validation settings menu. Once you set this, the formula will be able to find the named range "Months". I hope this helps.
how do you get the data in on the particular dates to change when you change the dates. example; if you write a note on january 15th, when you change to March the note is still in the cell you wrote it in even though the dates change
It is always better to express the version of the Excel that is used to demonstrate since Excel is growing fast with versions and audience may be having a different version. Just try to tell the version you are using in Demo. Thanks
Hi, I tried but the first monday is not showing up correctly it returns with Error #Name? also how do you only add the numbers Calendar mine is showing as complete dates
Why are you trying to rush in explaining I didn't understand what is the Motto or aim of this video Keep in mind you are addressing large and various level audiences Please not I am not criticizing you. You seem to be having vast knowledge on Excel and seem to be an expert I would appreciate if you could teach slowly that may lead to you to pinnacle of your aim Thanks for educating the community and appreciate your volunteer-ship Thanks a lot
Hello Trevor. I am so impressed with your excel worksheet calendar. Thank you so much. looking forward to improving my excel abilities.
thank you very much sir... i visited your website a year ago... and i got my current work bcoz of you... you help me a lot.. until now.. :)
thanks for uploading new videos,I've learned so much from you and may God bless you always,thanks so much from the bottom of my heart
+Arriane Viñas
Thank Arriane,
I am glad the tutorials have helped.
Trev
Thanks for your new update and obviously it is helpful and made our work easy.
Thanks Trevor, you are an inspiration.
Damn that is clever. Thanks for posting. Now I am off to practice this.
Thanks Trevor, very interesting and helpful
AWESOME! exactly what i needed
Thanks for uploading a very very useful calendar in Excel. I appreciate your innovative skill. Please upload some more useful user friendly techniques. I am very much interested to learn more from your time saving videos. Hope you will upload.
Hi Gopala,
Here is a link to the site.
www.onlinepclearning.com/
best wishes
Trev
Hi Trevor, thanks for your detailed instruction. In Cells E3 (End date), I tried formula '=EOMONTH(D3,0)' that returns the same result as yours. So we don't have to calculate the number of date in the month then calculate the last day of the month.
i have one questions like, i have predefined table(every month) which is we manually enter Calender Week as per the month, ( for ex:- this july 2018 -> cw 27, cw 28, cw 29, cw 30, cw 31..) , for this i want to do some automation in userform as well in Excel sheet also,, is there any method is there ? please help me if you come across or done before ?
Hi
How I Can keep The Cells Which I Will Used To Writing My Memo Saved With The Date Of The Day?
Best Regards,
Very useful, Thank you very much for sharing...
sir i had stuck in confusion. if suppose we select cell A1 =now() and cell B1 given time 18:00 how can set to minus all time A1 is now time is 06:00am and how can countdown this values? after complete time msg come to what i written in Cell C1 Like "Your countdown complete" is written in cell C1. one more thing and auto every second minus to my value what i written B1 cell.
How do you get the event you input into a particular date to not replicate to all other dates in the calendar?example; if you write a note on January 15th, when you change to March the note is still in the cell you wrote it in even though the dates change. Any help would be great. Thanks
Great Trevor! Thanks!!
Hi Trevor,
Your worksheet looks amazing, unfortunately the formulas don't work by me, what can i do to make it work?
thousand of thanks!!
Hi Trevor
First of all great calendar!! I hope that you can help me though, I have downloaded your calendar template but I am stuck on the cell D3; with this formula entered =DATE(E6,MATCH(C6,Months,0),1)-WEEKDAY(DATE(E6,MATCH(C6,Months,0),1),2)+1 it gives me error #NAME?
What can I do to make it work?
thank you for your time
Simona
Hi Simona, I had the same problem. Make sure that you create a named range called "Months" with every month in a calendar year. Then you format the cell for the month pull down menu to the named range "Months" in the DATA>Data Validation settings menu. Once you set this, the formula will be able to find the named range "Months". I hope this helps.
Sir,How do you make the calendar to where you are able to flip through the calendar without the data this is written in the white cells from staying?
Excel is probably not the best app to do this. Most platforms and email clients have a build in calendar.
Trev
After add text on the specific date, how to keep it on that particular date and not follow the calendar to another month?
how do you get the data in on the particular dates to change when you change the dates. example; if you write a note on january 15th, when you change to March the note is still in the cell you wrote it in even though the dates change
Good Evening. I know you wrote this a while ago but I am having the same problem can you remember how you fixed this? Any help would be fab. Thanks.
It is always better to express the version of the Excel that is used to demonstrate since Excel is growing fast with versions and audience may be having a different version. Just try to tell the version you are using in Demo.
Thanks
how do you put in the dates value on each cells from Monday thru Sunday?
Hi,
Here is a link to the web article.
There is a template you can download.
www.onlinepclearning.com/excel-calendar-spreadsheet/
Thanks a lot!
Hi, I tried but the first monday is not showing up correctly it returns with Error #Name? also how do you only add the numbers Calendar mine is showing as complete dates
Hi
Check the name that the formula is referencing. You can format dates with right click/ format / custom
Trev
Why are you trying to rush in explaining
I didn't understand what is the Motto or aim of this video
Keep in mind you are addressing large and various level audiences
Please not I am not criticizing you.
You seem to be having vast knowledge on Excel and seem to be an expert
I would appreciate if you could teach slowly that may lead to you to pinnacle of your aim
Thanks for educating the community and appreciate your volunteer-ship
Thanks a lot