if function and dates

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I am trying to sort invoices by date, however, the invoice
date is usually for the prior month. For example, an
August 10 invoice is for July.

I would like to write an If statement that says if the
invoice date is before the 15th of the month, use the
prior month (Aug 10 is a July billing month) and if the
invoice date is after the 15th, the billing month is for
the current month (Aug 30 is for August billing month).
Thanks
Matt
 
You may want to strip off the day portion of the date
depending on the format using LEFT() or RIGHT() and move
it into another column. With this you can write an IF
using this day column

Christy
 
Back
Top