Date issue
You can also try this:
=EOMONTH(A1,-1)-30
--
If this posting was helpful, please click on the Yes button.
Regards,
Michael Arch.
"Patrick C. Simonds" wrote:
I need to construct a formula which will subtract 1 month from the previous
month and return the first day of the preceding month.
Example:
A1 value is 24 April, I want A2's value to be 1 March
|