AW: Datumsformat in Textformat umwandeln
10.01.2006 09:14:23
WernerB.
Hallo Peter,
bitte sehr:
Sub NewDate()
Dim nTag As Variant, _
nDate As Date, vDate As Date
nDate = Range("navDate")
nTag = Weekday(nDate, vbMonday)
If nTag = 1 Then
nDate = nDate - 3
Else
nDate = nDate - 1
End If
'Schreibe in Zelle neben "navDate"
'das neue Datum
With Range("navdate").Offset(0, 1)
.ClearComments
.NumberFormat = "@"
.Value = CStr(nDate)
End With
'...oder sonstwo hin
With Range("B10")
.ClearComments
.NumberFormat = "@"
.Value = CStr(nDate)
End With
End Sub
Gruß
WernerB.