Complicated formula or look-up table help

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 10:01 PM.