PDA

Vollständige Version anzeigen : automatischer Eintrag


Murksi
27.03.2012, 06:11
Hallo Forum,

ich stehe mal wieder ein bischen auf dem Schlauch und habe eine (fast) Anfängerfrage.
In der beigefügten Datei (Ausschnitt aus einer größeren Tabelle) soll in Spalte N Zeile 5 immer das letzte Datum aus den vorhergehenden Spalten erscheinen, sobald in Zeile 4 "Ist per" eingetragen wird. Also z.B. für März 31.03., wenn in Spalte C Zeile 4 "Ist per" eingetragen ist. Wenn möglich, bitte eine Lösung mit Formel, nicht über VBA.

Danke schon mal im Voraus

Gruß
Murksi

zra8886
27.03.2012, 06:39
Hallo ???,

mit dem Format Text kann man nicht rechnen.
Deshalb:
<b><em>Tabelle1</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:35px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /><col style="width:76px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td><td>L</td><td>M</td><td>N</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Jan&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Feb&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Mrz&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Apr&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Mai&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Jun&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Jul&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Aug&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Sep&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Okt&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Nov&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Dez&nbsp;2012</b></td><td style="color:#000000; background-color:#FFFF99; text-align:center; " ><b>Summe</b></td><td style="color:#000000; background-color:#CCFFCC; text-align:center; " ><b>Summe</b></td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Ist&nbsp;per</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Ist&nbsp;per</b></td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFFFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFF99; text-align:center; " ><b>V-Ist&nbsp;per</b></td><td style="color:#000000; background-color:#CCFFCC; text-align:center; " ><b>Ist&nbsp;per</b></td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style="color:#000000; background-color:#CCCCFF; text-align:center; " ><b>31.01.2012</b></td><td style="color:#000000; background-color:#CCCCFF; text-align:center; " ><b>29.02.2012</b></td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#CCCCFF; ">&nbsp; </td><td style="color:#000000; background-color:#FFFF99; text-align:center; " ><b>31.12.2012</b></td><td style="color:#000000; background-color:#CCFFCC; text-align:center; " ><b>29.02.2012</b></td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel </td><td> Bereich </td></tr><tr><td>A5 </td><td>=WENN(A4="Ist&nbsp;per";DATUM(JAHR(A3);MONAT(A3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>B5 </td><td>=WENN(B4="Ist&nbsp;per";DATUM(JAHR(B3);MONAT(B3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>C5 </td><td>=WENN(C4="Ist&nbsp;per";DATUM(JAHR(C3);MONAT(C3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>D5 </td><td>=WENN(D4="Ist&nbsp;per";DATUM(JAHR(D3);MONAT(D3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>E5 </td><td>=WENN(E4="Ist&nbsp;per";DATUM(JAHR(E3);MONAT(E3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>F5 </td><td>=WENN(F4="Ist&nbsp;per";DATUM(JAHR(F3);MONAT(F3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>G5 </td><td>=WENN(G4="Ist&nbsp;per";DATUM(JAHR(G3);MONAT(G3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>H5 </td><td>=WENN(H4="Ist&nbsp;per";DATUM(JAHR(H3);MONAT(H3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>I5 </td><td>=WENN(I4="Ist&nbsp;per";DATUM(JAHR(I3);MONAT(I3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>J5 </td><td>=WENN(J4="Ist&nbsp;per";DATUM(JAHR(J3);MONAT(J3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>K5 </td><td>=WENN(K4="Ist&nbsp;per";DATUM(JAHR(K3);MONAT(K3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>L5 </td><td>=WENN(L4="Ist&nbsp;per";DATUM(JAHR(L3);MONAT(L3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>N5 </td><td>=MAX(A5:L5)</td><td>&nbsp;</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#99FF33; text-align:center; font-weight:bold; "><td colspan="3" > Zahlenformate </td></tr><tr valign="top" style="background-color:#99FF33; text-align:center; font-weight:bold; "><td> Zelle </td><td> Format </td><td> Wert </td></tr><tr><td>A3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">40909</td></tr><tr><td>B3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">40940</td></tr><tr><td>C3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">40969</td></tr><tr><td>D3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41000</td></tr><tr><td>E3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41030</td></tr><tr><td>F3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41061</td></tr><tr><td>G3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41091</td></tr><tr><td>H3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41122</td></tr><tr><td>I3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41153</td></tr><tr><td>J3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41183</td></tr><tr><td>K3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41214</td></tr><tr><td>L3 </td><td style="text-align:center; ">MMM JJJJ</td><td style="text-align:right; ">41244</td></tr><tr><td>M3 </td><td style="text-align:center; ">@</td><td style="text-align:right; ">Summe</td></tr><tr><td>N3 </td><td style="text-align:center; ">@</td><td style="text-align:right; ">Summe</td></tr><tr><td>A4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; ">Ist per</td></tr><tr><td>B4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; ">Ist per</td></tr><tr><td>C4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>D4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>E4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>F4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>G4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>H4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>I4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>J4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>K4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>L4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; "> </td></tr><tr><td>M4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; ">V-Ist per</td></tr><tr><td>N4 </td><td style="text-align:center; ">#.##0,00</td><td style="text-align:right; ">Ist per</td></tr><tr><td>A5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">40939</td></tr><tr><td>B5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">40968</td></tr><tr><td>C5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>D5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>E5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>F5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>G5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>H5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>I5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>J5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>K5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>L5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">&nbsp;</td></tr><tr><td>M5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">41274</td></tr><tr><td>N5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">40968</td></tr></table><b>Zellen mit Format Standard werden nicht dargestellt</b><br/><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFFF66; text-align:center; font-weight:bold; "><td colspan="7" > Füllfarben und Muster </td></tr><tr valign="top" style="background-color:#FFFF66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Rot </td><td> Grün </td><td> Blau </td><td> Color </td><td> Muster </td><td style="text-align:right" > Farbe </td></tr><tr><td>M3 </td><td style="text-align:right; ">255</td><td style="text-align:right; ">255</td><td style="text-align:right; ">153</td><td style="text-align:right; background-color:#FFFF99">10092543&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>N3 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; ">204</td><td style="text-align:right; background-color:#CCFFCC">13434828&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>M4 </td><td style="text-align:right; ">255</td><td style="text-align:right; ">255</td><td style="text-align:right; ">153</td><td style="text-align:right; background-color:#FFFF99">10092543&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>N4 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; ">204</td><td style="text-align:right; background-color:#CCFFCC">13434828&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>A5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>B5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>C5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>D5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>E5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>F5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>G5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>H5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>I5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>J5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>K5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>L5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; background-color:#CCCCFF">16764108&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>M5 </td><td style="text-align:right; ">255</td><td style="text-align:right; ">255</td><td style="text-align:right; ">153</td><td style="text-align:right; background-color:#FFFF99">10092543&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr><tr><td>N5 </td><td style="text-align:right; ">204</td><td style="text-align:right; ">255</td><td style="text-align:right; ">204</td><td style="text-align:right; background-color:#CCFFCC">13434828&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr></table><b>Zellen mit Füllfarbe automatisch werden nicht dargestellt</b><br/><br/><a href="http://c.excelhost.de/c_beverly/getfile.php?id=122" onclick="window.open(this.href);return false">Tabellendarstellung in Foren Version 5.42</a><br/><br/>
mfg
Roland

Murksi
27.03.2012, 08:12
Super Roland,

danke für die schnelle Antwort. Auf den Gedanken, den Text aus Zeile 3 zu verwenden, war ich noch gar nicht gekommen. Gesucht hatte ich die MAX - Funktion. Manchmal sieht man den Wald vor Bäumen eben nicht.

Gruß
Murksi

zra8886
27.03.2012, 10:22
Hi,
...Auf den Gedanken, den Text aus Zeile 3 zu verwenden, war ich noch gar nicht gekommen. ...

Falsch. Das ist kein Text.

Da ist eine Zahl (mit der man rechnen kann) in der Zelle drin. Das Format in der Zelle A3 ist MMM JJJJ.

Also nochmal zur Verdeutlichung: Mit dem Zellenformat Text funktioniert das nicht.

mfg
Roland

mücke
27.03.2012, 10:54
Moin Roland,

... Mit dem Zellenformat Text funktioniert das nicht ...
schau mal hier:

<b><em>Tabelle1</em></b><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><colgroup><col style="font-weight:bold; width:40px;" /><col style="width:106px;" /><col style="width:106px;" /></colgroup><tr style="background-color:#99CCFF; text-align:center; font-weight:bold; "><td>&nbsp;</td><td>A</td><td>B</td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">3</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Januar&nbsp;12</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Februar&nbsp;12</b></td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">4</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Ist&nbsp;per</b></td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " ><b>Ist&nbsp;per</b></td></tr><tr><td style="background-color:#99CCFF; text-align:center; font-weight:bold; ">5</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >31.01.2012</td><td style="color:#000000; background-color:#FFFFFF; text-align:center; " >29.02.2012</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td colspan="3" > verwendete Formeln </td></tr><tr valign="top" style="background-color:#FFCC66; text-align:center; font-weight:bold; "><td> Zelle </td><td> Formel </td><td> Bereich </td></tr><tr><td>A5 </td><td>=WENN(A4="Ist&nbsp;per";DATUM(JAHR(A3);MONAT(A3)+1;0);"")</td><td>&nbsp;</td></tr><tr><td>B5 </td><td>=WENN(B4="Ist&nbsp;per";DATUM(JAHR(B3);MONAT(B3)+1;0);"")</td><td>&nbsp;</td></tr></table><br/><table border="1" cellspacing="0" cellpadding="0" style="border-color:#000000; border-width: 1px; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "><tr style="background-color:#99FF33; text-align:center; font-weight:bold; "><td colspan="3" > Zahlenformate </td></tr><tr valign="top" style="background-color:#99FF33; text-align:center; font-weight:bold; "><td> Zelle </td><td> Format </td><td> Wert </td></tr><tr><td>A3 </td><td style="text-align:center; ">@</td><td style="text-align:right; ">'Januar 12</td></tr><tr><td>B3 </td><td style="text-align:center; ">@</td><td style="text-align:right; ">'Februar 12</td></tr><tr><td>A4 </td><td style="text-align:center; ">@</td><td style="text-align:right; ">Ist per</td></tr><tr><td>B4 </td><td style="text-align:center; ">@</td><td style="text-align:right; ">Ist per</td></tr><tr><td>A5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">40939</td></tr><tr><td>B5 </td><td style="text-align:center; ">TT.MM.JJJJ</td><td style="text-align:right; ">40968</td></tr></table><b>Zellen mit Format Standard werden nicht dargestellt</b><br/><br/><a href="http://excel-inn.de/dateien/vba_beispiele/tabellenanzeige_in_html_addin.zip" onclick="window.open(this.href);return false">Tabellendarstellung in Foren Version 5.48</a><br/><br/>

Murksi
27.03.2012, 10:55
:upps: Hast natürlich recht. Nochmals Danke für die Lösung.:bye:

Gruß
Murksi

zra8886
28.03.2012, 06:44
Moin Dirk,

...schau mal hier...

Funktioniert. Danke für die Info.

Trotzdem rechne ich persönlich bei Datumsangaben lieber mit Zahlen und nicht mit Text.

Braucht z. B. nur einer kommen und sagen: aus Januar 12 wird Januar 2012.
Format umstellen - fertig.

mfg
Roland