Dates / Days
 

Hello,

In cash mngnt spreadsheet. I have in A5 the current month: 01-Feb-05, I'd
like, if possible, D13 to be 1st day of A5, D14 to be 2nd day of A5, D15 to
be 3rd day of A5 etc.
Also, I'd like, if possible, to display in D13 "1", D14 "2", D15 "3", etc.

Thank you in advance for any help.

D13: = DATE(YEAR(A5),MONTH(A5),1)
D14: =D13+1
D15: =D14+1
etc.

format them all as custom format d

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" wrote in message
...
Hello,

In cash mngnt spreadsheet. I have in A5 the current month: 01-Feb-05, I'd
like, if possible, D13 to be 1st day of A5, D14 to be 2nd day of A5, D15
to
be 3rd day of A5 etc.
Also, I'd like, if possible, to display in D13 "1", D14 "2", D15 "3", etc.

Thank you in advance for any help.