# Formula help

#### Alisya

##### Well-known Member
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

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### barry houdini

##### MrExcel MVP
Try this formula

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

#### PA HS Teacher

##### Well-known Member
="Debit Interest " & TEXT(DATE(YEAR(NOW()),MONTH(NOW())-1,1), "mmmm yyyy")

#### Alisya

##### Well-known Member
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>

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

#### Alisya

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

Awesome thanks

Replies
3
Views
104
Replies
1
Views
165
Replies
1
Views
123
Replies
2
Views
125
Replies
8
Views
634

1,171,533
Messages
5,876,049
Members
433,170
Latest member
Gott

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back