Quote:
Originally Posted by macropod
In F3, try:
=TEXT(DATE(YEAR(TODAY()), <snip> ^($D3-1))),1)
|
That may just do it. I tried to figure it out on my own based on your original solution, but I couldn't reverse engineer it so I had to come back. It seems to be OK, but because I haven't had a chance to see what you changed yet, I haven't figured out why it works. Then again, I may never. I'll play with it tomorrow at work and make sure I'm not premature in calling it fixed, but I can't tell you how much I appreciate your continued effort. Chat tomorrow.