Thread: Date/time increment specifier
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
adimar adimar is offline
external usenet poster
  
Posts: 49
Default Date/time increment specifier
Date + 1 increments the date.
How do you increment date at year, month, hour, min, or second?

Ex: Is there anything more compact for €śDate + 1 year€ť than DATE(YEAR(Date)
+ 1, MONTH(Date), DAY(Date))?

Thank you.

Reply With QuoteReply With Quote