Quote:
Originally Posted by macropod
From what you've described, I believe you can use:
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+MOD(DATEDI F(TODAY(),DATE(YEAR(TODAY())<see original posting>.
|
We have a winner!
It works like a champ. I'm poking at it a bit to understand what you did, but thanks a bunch. It will save me lots of time and very elegantly I must say.