Thread: Calculate date for one month previous?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Calculate date for one month previous?
=DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))

Just be caareful about going back to a short month.
--
Gary''s Student - gsnu200852


"liirogue" wrote:

Cell A1 has 2/1/09 in it. Is there a way cell A2 can calculate the date of
the previous month, 1/1/09?
Reply With QuoteReply With Quote