lionstud31
Board Regular
- Joined
- Oct 16, 2006
- Messages
- 89
I am trying to make my spreadsheet update the dates in it by just putting in the year. Here's what I'm doing exactly: In cell A1 I want to enter a year. Then, I want the first day of each month to be calculated starting in D1 heading right (Jan 1st (and the year) in D1, Feb 1st (and the year) in E1 and so on). I also want the month end in the second row (Jan 31st (and the year) in D2, Etc. Anyone know how to do this? Thanks in advance.[/img]