muddan madhu wrote:
try this

=IF(DAY(B1)15,"End "&TEXT(B1,"mmm"),"Mid "&TEXT(B1,"mmm"))

I need your help...

[quoted text clipped - 22 lines]

Thank you!

Hi muddan madhu,
I tried it and it works. Thank you so much!

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