Posted to microsoft.public.excel.misc

Peter

external usenet poster

Posts: 349

Manipulating dates

When I apply this formula - =EOMNTH(E28,3) - to a date Jan-08 in cell E28
Excel gives me the correct answer Apr-08. When I use the same approach in an
IF statement it doesn't work. Here's the formula I'm using -
=IF(E28<=$B$78,E28,IF(E28-$B$78<6,EOMONTH(E28,3),E28))

$B$78 is TODAY - Oct-07

Can any body help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Manipulating a two-axis graph.	FTD	Charts and Charting in Excel	4	October 12th 07 11:46 PM
manipulating dates	ghostinhawaii	Excel Worksheet Functions	2	March 24th 07 05:16 AM
Manipulating dates (was Add 6 months to a date)	Bill Ridgeway	New Users to Excel	2	March 31st 06 07:46 PM
manipulating columns	GISDude	Charts and Charting in Excel	0	March 1st 06 10:40 PM
Manipulating shapes	thePriest	Excel Discussion (Misc queries)	0	April 20th 05 06:41 PM

All times are GMT +1. The time now is 12:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us