Dates / Days

J

Jeff

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.
 
B

Bob Phillips

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)
 
Top