View Single Post
 
Old 04-30-2014, 07:24 PM
wmpwi wmpwi is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Apr 2014
Posts: 7
wmpwi is on a distinguished road
Thumbs up

Quote:
Originally Posted by macropod View Post
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.

Last edited by wmpwi; 04-30-2014 at 07:25 PM. Reason: hot dog fingers.
Reply With Quote