Thread: Return 1st of the Month
View Single Post
  #13   Report Post  
bj
 
Posts: n/a
Default
You could also use =eomonth(c4,-1)+1

"JJalomo" wrote:

I need a formula or function which will return the first of the month. For
example, if Cell c4 contains 2/15/05, i need to return 2/01/05 in cell d4.

Cell c4 can contain any date.


Reply With QuoteReply With Quote