Excel to automatically enter a date

[Guest]

I am using Excell 2000.
I have created an invoice template. One column is for date entry, the next
column for the service, and then an amount column. The bottom line totals all
the amount entries for a grand total. Pretty standard.

On the bottom grand total line, in the date column, I want to enter the last
day of the month. I need an IF formula (I think) that will look at the first
cell in the date column. If it sees an entry (i.e. >0), it then calculates
the last day of that month and enters it on the bottom line. So if I am
entering services for June, it will see 06/01/05 in the first cell, and
automatically enter 06/30/05 in the bottom cell.

Thanks for any help!

 

[Peo Sjoblom]

Assume the date you enter is in A1, then this will give you the last day of
the same month

=DATE(YEAR(A1),MONTH(A1)+1,)


--
Regards,

Peo Sjoblom

(No private emails please)