Posted to microsoft.public.excel.misc

external usenet poster

Posts: 107

IF MAX formula using dates

=IF($F4="On Board",MAX(0,((S$1-$M4)/7))*Q4,"")

S1= 3/31/2010
M4= 10/15/2009
Q4= $573

How can I fix the formula above so it will correctly calculate the cost
based on a 2009 date, or a 2010 date. Currently, the formula only works if
M4 has a date of 2010.

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
Formula for Dates	Daren	Excel Worksheet Functions	18	October 25th 08 03:35 AM
Sum If formula for between dates	Peter	Excel Discussion (Misc queries)	6	May 30th 08 07:17 PM
Dates formula	davey	Excel Worksheet Functions	6	July 21st 07 08:18 PM
Formula with dates	lara5555	Excel Discussion (Misc queries)	7	April 4th 06 12:43 PM
how do I use if formula using dates?	Simone	Excel Worksheet Functions	4	November 8th 05 02:40 AM

All times are GMT +1. The time now is 11:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us