|
|
#6
01-12-2012, 07:56 AM
|
|||
|
|||
Thanks Colin, but I can't seem to get them to return the results I would expect. The results they are returning are as follows:
Formula1 3 Formula2 01/02/2012 Formula3 40940 The result should in face be 2 as Jan - March is 3 months, we do not want to include the current month (Jan) so want the formula to calculate from Feb - March which would me 2 remaining months. Your second formula is similar to what I have been trying to do but just can't seem to get it to work. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| help with a look up or if formula | beb1227 | Excel | 3 | 12-31-2011 01:08 PM |
 help with formula?
|
doczilla | Excel | 2 | 09-25-2011 04:14 PM |
|
Help with Formula
|
Corca | Excel | 6 | 02-22-2010 09:40 PM |
|
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |
| Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
Windows 7 32bit 
Office 2007
Threaded Mode