Re: Monat durch Formel ermitteln?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hallo Michael,

Michael Schwimmer schrieb:

Da wäre dann vielleicht eine VBA-Funktion angebracht. 

abgesehen davon, dass Boris eine mega Formel geliefert hat, hier noch eine
benutzerdefinierten Funktion, die den Vorteil hat dass die Eingabe einfacher ist
und sie nicht als Matrixformel abgeschlossen werden muss:

Public Function MonatVorhanden(ByVal rngBereich As Range, _
                              lngMonat As Long) As String
  If Evaluate("=OR(IF(ISNUMBER(" & rngBereich.Address & "),MONTH(" _
              & rngBereich.Address & ")=" & lngMonat & "))") Then
     MonatVorhanden = MonthName(lngMonat)
  End If
End Function

Aufzurufen z.B. mit:
=MonatVorhanden(B3:B400;A1)


Mit freundlichen Grüssen
Melanie Breden

--
- Microsoft MVP für Excel -
Microsoft Excel - Die ExpertenTipps http://tinyurl.com/cmned
Das Excel-VBA Codebook http://excel.codebooks.de
Excel-Auftragsprogrammierung 

.

Relevant Pages

  • Re: Benefits of upgrading to Excel2003
    ... You probably don't have access to Excel 2002 and excel 2003 so I've ... Key new features in Microsoft Excel ... Web queries to Extensible Markup Language files. ... If you are not using the specific language version of Microsoft Office ...
    (microsoft.public.excel.misc)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... "Microsoft also released a Cube add-in for Excel, ... >I have watched webcast after webcast about SQL Server 2005 Business ...
    (microsoft.public.sqlserver.olap)
  • Re: Client tools for SQL Server 2005 Analysis Services - Where are they?
    ... >>I have watched webcast after webcast about SQL Server 2005 Business ... >> touches on their new clients, as well as many other Microsoft Partners ... >> Then there is Excel. ... >> to find that it still costs more to buy the client tools which have ...
    (microsoft.public.sqlserver.olap)
  • Re: Excel 2004 crashes with Right Mouse Button click in OS X 10.4.8
    ... Is your RAM Apple branded, ... Microsoft Office applications? ... I launch Microsoft Excel. ... USB Device: Apple Internal Keyboard / Trackpad, Apple Computer, Up to ...
    (microsoft.public.mac.office.excel)
  • Re: why>?
    ... also; back in the 90s; it might have been a good idea to use Excel. ... Adobe Acrobat and DB2 mainframes-- it is obvious that they need to wake ... Microsoft dug their own hole with regard to antitrust. ...
    (microsoft.public.excel)