Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
Find number of days between to dates | Excel Worksheet Functions | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions |