Date functions

[C Money]

I'm creating a commissions statement, and the statement
issued is always for the previous month. For instance
we're in June currently, but the statements are being
issued for sales in May. I know you can refer back a month
using the EDATE functiong but I'm not sure how to do it.
Do I need to have two cells to do this, one for the
current month and then another one to use the edate
function to list the previous month or can I do all of
this in one cell?

 

[Ron Rosenfeld]

I'm creating a commissions statement, and the statement
issued is always for the previous month. For instance
we're in June currently, but the statements are being
issued for sales in May. I know you can refer back a month
using the EDATE functiong but I'm not sure how to do it.
Do I need to have two cells to do this, one for the
current month and then another one to use the edate
function to list the previous month or can I do all of
this in one cell?

It's not clear exactly what you want to do.

Here are some formulas that might help.

Last day of last month:

=TODAY() - DAY(TODAY())

One month back:

=EDATE(TODAY(),-1)


--ron