if function and dates

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
 
C

Christy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed with a formula for dates in excel 2007 2
Dates - Need to display date one month prior to user-entered date 13
How do I write an If(And( function using dates as my logical test? 4
Autofill from months 0
Given a date, how do I get the 1st date and the last date of theprevious month? 5
Date 2
asign the next 10th as the due date. 3
Calculating Dates 6

Top