Complicated formula or look-up table help

		Microsoft Office Forums > Microsoft Excel > Excel
Complicated formula or look-up table help

FAQ

Thread Tools

Display Modes

04-18-2014, 07:10 AM

wmpwi

Windows 7 32bit Complicated formula or look-up table help

Office 2010 32bit

Novice

Join Date: Apr 2014

Posts: 7

Problem Solved!

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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 07:29 AM.