Thread: 2 functions in 1
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 2 functions in 1
=IF(V4="","",DATE(YEAR(V4),MONTH(V4)-1,DAY(V4)))
--
Gary''s Student - gsnu200846
Reply With QuoteReply With Quote