From: Hannah on 25 Mar 2010 05:00 Good morning I would like to write an if formula that will provide me with the month (in words) if the date in a column falls between certain values, this needs to be ongoing as the spreadsheet concerned will report ongoing data therefore there will be more than seven sets of criteria to be evaluated. Please could you let me know if this is possible? Many thanks From: Jacob Skaria on 25 Mar 2010 05:05 With date in cell A1 try =TEXT(A1,"mmmm") =TEXT(A1,"mmm") -- Jacob "Hannah" wrote: > Good morning > > I would like to write an if formula that will provide me with the month (in > words) if the date in a column falls between certain values, this needs to be > ongoing as the spreadsheet concerned will report ongoing data therefore there > will be more than seven sets of criteria to be evaluated. > > Please could you let me know if this is possible? > > Many thanks From: Hannah on 25 Mar 2010 05:21 Brilliant - thank you! "Jacob Skaria" wrote: > With date in cell A1 try > =TEXT(A1,"mmmm") > > =TEXT(A1,"mmm") > > -- > Jacob > > > "Hannah" wrote: > > > Good morning > > > > I would like to write an if formula that will provide me with the month (in > > words) if the date in a column falls between certain values, this needs to be > > ongoing as the spreadsheet concerned will report ongoing data therefore there > > will be more than seven sets of criteria to be evaluated. > > > > Please could you let me know if this is possible? > > > > Many thanks  |  Pages: 1 Prev: General CalculatorNext: Functions on filtered data