Just a silly problem I have run into.
I have this formula exactly:
=DATE(YEAR(TODAY()), MONTH(TODAY())-2, 0)&" - "&DATE(YEAR(TODAY()), MONTH(TODAY()), 0)
What displays is "40298 - 40390".
What I want to display is "4/30/2010 - 7/31/2010".
Thanks!
Bookmarks