On Wed, 18 May 2005 06:48:03 -0700, "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
=A1-DAY(A1)+1
Substitute TODAY() for A1.
--ron
|