Excel Worksheet Calendar

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ต.ค. 2024

ความคิดเห็น • 34

  • @nigeltimothy5054
    @nigeltimothy5054 7 ปีที่แล้ว

    Hello Trevor. I am so impressed with your excel worksheet calendar. Thank you so much. looking forward to improving my excel abilities.

  • @ReynaldsonAceberos
    @ReynaldsonAceberos 8 ปีที่แล้ว

    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.. :)

  • @anaisv.7716
    @anaisv.7716 9 ปีที่แล้ว +1

    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

    • @OnLinePCLearning
      @OnLinePCLearning  9 ปีที่แล้ว

      +Arriane Viñas
      Thank Arriane,
      I am glad the tutorials have helped.
      Trev

  • @SERAJ9156
    @SERAJ9156 9 ปีที่แล้ว

    Thanks for your new update and obviously it is helpful and made our work easy.

  • @sonnyschade1299
    @sonnyschade1299 9 ปีที่แล้ว

    Thanks Trevor, you are an inspiration.

  • @zacandmillie
    @zacandmillie 9 ปีที่แล้ว

    Damn that is clever. Thanks for posting. Now I am off to practice this.

  • @janezklun
    @janezklun 9 ปีที่แล้ว

    Thanks Trevor, very interesting and helpful

  • @thirsty247247
    @thirsty247247 8 ปีที่แล้ว

    AWESOME! exactly what i needed

  • @1gopalakrishnarao
    @1gopalakrishnarao 9 ปีที่แล้ว

    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.

    • @OnLinePCLearning
      @OnLinePCLearning  9 ปีที่แล้ว

      Hi Gopala,
      Here is a link to the site.
      www.onlinepclearning.com/
      best wishes
      Trev

  • @Hikarulight90
    @Hikarulight90 7 ปีที่แล้ว

    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.

  • @arumohajcet
    @arumohajcet 6 ปีที่แล้ว

    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 ?

  • @MahmoudMahmoud-kh2rm
    @MahmoudMahmoud-kh2rm 9 ปีที่แล้ว +1

    Hi
    How I Can keep The Cells Which I Will Used To Writing My Memo Saved With The Date Of The Day?
    Best Regards,

  • @primitivestreakman
    @primitivestreakman 8 ปีที่แล้ว

    Very useful, Thank you very much for sharing...

  • @TRADEEDUCATOR
    @TRADEEDUCATOR 7 ปีที่แล้ว

    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.

  • @paulagolder6404
    @paulagolder6404 7 ปีที่แล้ว

    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

  • @diemswo
    @diemswo 8 ปีที่แล้ว

    Great Trevor! Thanks!!

  • @manonlindeman
    @manonlindeman 7 ปีที่แล้ว

    Hi Trevor,
    Your worksheet looks amazing, unfortunately the formulas don't work by me, what can i do to make it work?

  • @onlymodou
    @onlymodou 7 ปีที่แล้ว

    thousand of thanks!!

  • @simonatorni9784
    @simonatorni9784 7 ปีที่แล้ว

    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

    • @musicianathome
      @musicianathome 7 ปีที่แล้ว

      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.

  • @Jakewhodoe
    @Jakewhodoe 8 ปีที่แล้ว

    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?

    • @OnLinePCLearning
      @OnLinePCLearning  8 ปีที่แล้ว

      Excel is probably not the best app to do this. Most platforms and email clients have a build in calendar.
      Trev

  • @chadaruta7211
    @chadaruta7211 8 ปีที่แล้ว

    After add text on the specific date, how to keep it on that particular date and not follow the calendar to another month?

  • @thirsty247247
    @thirsty247247 8 ปีที่แล้ว

    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

    • @paulagolder6404
      @paulagolder6404 7 ปีที่แล้ว

      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.

  • @krismaly6300
    @krismaly6300 7 ปีที่แล้ว

    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

  • @goldendiamond191
    @goldendiamond191 8 ปีที่แล้ว

    how do you put in the dates value on each cells from Monday thru Sunday?

    • @OnLinePCLearning
      @OnLinePCLearning  8 ปีที่แล้ว

      Hi,
      Here is a link to the web article.
      There is a template you can download.
      www.onlinepclearning.com/excel-calendar-spreadsheet/

    • @goldendiamond191
      @goldendiamond191 8 ปีที่แล้ว

      Thanks a lot!

  • @jfarooq6
    @jfarooq6 8 ปีที่แล้ว

    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

    • @OnLinePCLearning
      @OnLinePCLearning  8 ปีที่แล้ว

      Hi
      Check the name that the formula is referencing. You can format dates with right click/ format / custom
      Trev

  • @krismaly6300
    @krismaly6300 7 ปีที่แล้ว

    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