Sorry - seems to work now, what sure what the problem was earlier.
Cheers,
Matt
"Matt D Francis" wrote:
Sorry to intrude, I need a similar function but will always return the start
date of the CURRENT month - i.e date sheet is opened? I tried using TODAY()
in place of C4 in this formula but no luck - any suggestions?
Matt
"Gary Brown" wrote:
=date(year(c4),month(c4),1)
HTH,
Gary Brown
"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.
|