Dates

G

Guest

I have three cells on my worksheet that use dates. The dates that I use are
the last day of the month. I want the first one to be inputed. The third one
I want to be the same as the first, but the second to be the 15th of the
month.

date1 7/31/2006
date2 7/15/2006
date3 7/31/2006

How can I do this since some months have 30 and some have 31?
 
F

Flintstone

Justlearnin:

Assuming cell A1 is your input date, place this formula in cell A2.

=DATE(YEAR(A1),MONTH(A1),15)

Place this formula in cell A3.

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


Matt
 

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

Top