Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2014, 07:10 AM
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 Problem Solved!

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



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 06:37 AM.


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