Thread: Date Defaulting
View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

I think this should do it:
B1: =EOMONTH(A1,-1)+1

Regards,
Ron