Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 04-30-2014, 07:24 PM
wmpwi wmpwi is offline Complicated formula or look-up table help Windows 7 32bit Complicated formula or look-up table help Office 2010 32bit
Novice
Complicated formula or look-up table help
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated formula or look-up table help complicated mail merge is possible? chedlee Mail Merge 1 03-07-2014 12:29 AM
Complicated Formula Needed midgetmogalle Excel 14 01-29-2014 10:26 AM
help with complicated formula flyinghigher2011 Excel 6 07-30-2013 02:16 PM
Complicated formula or look-up table help Formula and Table Help! steveman1234 Word Tables 2 03-28-2010 06:20 PM
Using calculated field - WHY IS IT SO COMPLICATED? Riorin Word 0 10-30-2009 12:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft