Thread: Date issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Date issue

I need to construct a formula which will subtract 1 month from the previous
month and return the first day of the preceding month.

Example:
A1 value is 24 April, I want A2's value to be 1 March