MsgBox (DateDiff("d", "25/04/2011", "25/04/2014")) MsgBox (Format(DateAdd("yyyy", 1, "25/04/2014")))
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question=DATE(ANNEE(AUJOURDHUI())+1;MOIS(A1);JOUR(A1))
=DATEVALUE(year(date)+1;month(A1);day(A1))
= DateValue(Year(Date + 1) & "/" & Month(Range("A1")) & "/" & Day(Range("A1")))
=SI(DATE((ANNEE(H6)-ANNEE(AUJOURDHUI()))>=1;MOIS(H6);JOUR(H6));DATE(ANNEE(AUJOURDHUI())+1;MOIS(H6);JOUR(H6));"")
=If(DATEVALUE(year(A1)-year(today)>=1;=DATEVALUE(year(date)+1;month(A1);day(A1));0)
dim x as single IF DateValue(Year(Date + 1) & "/" & Month(Range("A1")) & "/" & Day(Range("A1")))-DateValue(Year(Today()) & "/" & Month(Range("A2")) & "/" & Day(Range("A2")))>=1 Then x=DateValue(YEAR(Date+1)&"/"&Month(Range("A1"))& "/" & Day(Range("A1"))) Else X=0 end if