Loading ...
Sorry, an error occurred while loading the content.

Re: ]] XL-mania [[ Ask: End of The Month

Expand Messages
  • edi edison
    you can try  this : =DATE(YEAR(A1),1+MONTH(A1),1)-1   thank u   Edi ________________________________ From: Quality Assurance
    Message 1 of 5 , Mar 8, 2011
    View Source
    • 0 Attachment
      you can try  this :
       

      =DATE(YEAR(A1),1+MONTH(A1),1)-1

       

      thank u

       

      Edi




      From: Quality Assurance <quality.assurance@...>
      To: XL-mania@yahoogroups.com
      Sent: Wednesday, March 9, 2011 8:53:35
      Subject: ]] XL-mania [[ Ask: End of The Month

       

      Dear Moderator,
       
      Please give me your advice for this newbie on excel.
       
      Untuk mengetahui "tanggal terakhir dalam suatu bulan pakai formula apa ya?"
       
      Misal :
      January itu End Of the Monthnya = 31-Jan-2011
      February itu End Of the Monthnya = 28-Feb-2011
       
      Secara automatic muncul demikian, setelah disorot salah satu tanggal dalam 1 bulan tersebut.
       
      Kalao ada selain pakai formula =EOMONTH() yaaa, kerena perlu install ToolPak Add in lagi.
       
      Thanks a lot for your advice
       
      Salam
       

    • STDEV(i)
      misal suatu data DATE (tanggal berapa saja, asal bermilai 0) ada di A1 Tgl akhir bulan (data date) = DATE(Year(A1), Month(A1)+1,0) Jumlah hari (bilangan
      Message 2 of 5 , Mar 8, 2011
      View Source
      • 0 Attachment
        misal suatu data DATE (tanggal berapa saja, asal bermilai > 0)  ada di A1

        Tgl akhir bulan (data date)
        = DATE(Year(A1), Month(A1)+1,0)

        Jumlah hari (bilangan asli) dlm bulan tsb
         =DAY(DATE(Year(A1), Month(A1)+1,0))



        2011/3/9 Quality Assurance <quality.assurance@...>

        Dear Moderator,
        Please give me your advice for this newbie on excel.
        Untuk mengetahui "tanggal terakhir dalam suatu bulan pakai formula apa ya?"
        Misal :
        January itu End Of the Monthnya = 31-Jan-2011
        February itu End Of the Monthnya = 28-Feb-2011
        Secara automatic muncul demikian, setelah disorot salah satu tanggal dalam 1 bulan tersebut.
        Kalao ada selain pakai formula =EOMONTH() yaaa, kerena perlu install ToolPak Add in lagi.
        Thanks a lot for your advice
        Salam

      • summonery
        saya coba bantu ya, coba: =DATE(YEAR(A1),MONTH(A1)+1,0)
        Message 3 of 5 , Mar 8, 2011
        View Source
        • 0 Attachment
          saya coba bantu ya,

          coba:
          =DATE(YEAR(A1),MONTH(A1)+1,0)


          >semoga bermanfaat



          --- In XL-mania@yahoogroups.com, "Quality Assurance" <quality.assurance@...> wrote:
          >
          > Dear Moderator,
          >
          > Please give me your advice for this newbie on excel.
          >
          > Untuk mengetahui "tanggal terakhir dalam suatu bulan pakai formula apa ya?"
          >
          > Misal :
          > January itu End Of the Monthnya = 31-Jan-2011
          > February itu End Of the Monthnya = 28-Feb-2011
          >
          > Secara automatic muncul demikian, setelah disorot salah satu tanggal dalam 1 bulan tersebut.
          >
          > Kalao ada selain pakai formula =EOMONTH() yaaa, kerena perlu install ToolPak Add in lagi.
          >
          > Thanks a lot for your advice
          >
          > Salam
          >
        Your message has been successfully submitted and would be delivered to recipients shortly.