View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Raine via OfficeKB.com Raine via OfficeKB.com is offline
external usenet poster
 
Posts: 4
Default Formula convert date to month format

Teethless mama wrote:
=IF(DAY(A2)<16,"Mid ","End ")&TEXT(A2,"mmm")

I need your help...

[quoted text clipped - 22 lines]

Thank you!


Thank you for the help. It really works.. Have a nice day! =)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200906/1