Hi Garry,
Am Tue, 23 Sep 2014 19:49:55 -0400 schrieb GS:
=IF(MONTH(A1)<7,DATE(YEAR(A1),7,1),DATE(YEAR(A1)+1 ,1,1))
Perhaps, though, our local formula wizard Claus will have something
better...
;-)
There are other ways but none so short and clear than yours
Regards
Claus B.
I like to reflect the logic in my formulas, though I do hate using cell
addresses! You have a knack for brevity that I also like, but I find
using named refs easier for users to understand what a formula does!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion