=date(year(c4),month(c4),1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"JJalomo" wrote in message
...
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.
|