Formula help

[Alisya]

How could i produce the below but as formula rather than manual input, i would like the formula to always return the month before, so we are in march now so i would like to see February and in April i would like to see March etc


Debit Interest February 2009

 

[barry houdini]

Try this formula

="Debit Interest "&TEXT(TODAY()-DAY(TODAY()),"mmmm yyyy")

 

[PA HS Teacher]

How about:
="Debit Interest " & TEXT(DATE(YEAR(NOW()),MONTH(NOW())-1,1), "mmmm yyyy")

 

[Alisya]

Try this formula

="Debit Interest "&TEXT(TODAY()-DAY(TODAY()),"mmmm yyyy")

Barry i forgot to mention that in column D there are negative and positive amounts, if an amount is positive then it would be Credit Interest February 2009 else Debit Interest February 2009

<TABLE style="WIDTH: 178pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=237 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 134pt; mso-width-source: userset; mso-width-alt: 6546" width=179><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=58 height=17 x:str="Interest ">Interest </TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 134pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=179>Description</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num="-9.16">-9.16 </TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Debit Interest February 2009</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num="1.1">1.10 </TD><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">Credit Interest February 2009</TD></TR></TBODY></TABLE>

 

[Sal Paradise]

Try:
=IF(D1>0,"Credit","Debit")&" Interest "&TEXT(TODAY()-DAY(TODAY()),"mmmm yyyy")

 

[Alisya]

Try:
=IF(D1>0,"Credit","Debit")&" Interest "&TEXT(TODAY()-DAY(TODAY()),"mmmm yyyy")

Awesome thanks