On 2002-05-01 13:41, Corticus wrote:
In my first cell I have a date, say
1/1/2001
In the next cell I want the date at the end of the month(I can't use EOmonth):
1/31/2001
VBA has the DateAdd function which is perfect but I can't use it in the spreadsheet. Help!
On 2002-05-02 05:52, Corticus wrote:
Yes!!
=Date(year(A1),Month(A1)+1),Day(A1))-1
worked perfect,
Thanks for the replies!!
By the way, I couldn't use EoMonth because I send this spreadsheet all over the state and if the analysis toolkit wasn't available on someone's system, it would be a big pain.
On 2002-05-02 10:55, Corticus wrote:
Fortunately, I usually start with the first day of the month, but not always. So if anyone knows a way to use EOmonth(which is what I want) without having the Analysis Toolkit installed, that would be great.