2

enter image description here

I need help writing a formula for the following. superuser sample I hope you can see my image, and I explain myself well enough.

I want column L (my new column) to display column I(dollar amount) if Column C date is before Aug 31, 2015.

I want column M (my new column) to display the amount in Column I if the date is after Sept 1, 2015.

Column C has a name displayed as a title, column G has payment details listed. Then, the dates under each display name are listed in column C. charge codes are in column D, descriptions are in Column E, columns F,G,H are blank, and lastly, amounts are listed in column I.

Looking forward to a simple solution! Carla

Michael Frank
  • 8,091
  • 3
  • 43
  • 54
Carla
  • 17
  • 1
  • 1
  • 6

1 Answers1

5

You can use the DATE(year, month, day) function in an IF statement to compare dates.

For column L, you want to use something like:

=IF(C2<=DATE(2015,8,31),I2,"")

IF the value in C2 is less than (<=) or equal 31/08/2015 show the value in I2, else show nothing.

For column M, you can do the exact same thing but use greater than (>=) instead:

=IF(C2>=DATE(2015,9,1),I2,"")

enter image description here

Michael Frank
  • 8,091
  • 3
  • 43
  • 54