- Joined
- Dec 21, 2010
- Messages
- 1
- Reaction score
- 0
- Points
- 1
Need help setting up a fixed date annual calender. Have set one for 2010 but what needs to be done for 2011 so I don't have to go threw and change the year on each date.
Have formula: =DATETOTEXT(DATE(year,month,day),format*number) filled in that =; =DATETOTEXT(DATE(2011,1,1),3) or
printed in spreadsheet as = Sat, Jan 01, 2011
I have tried adding +1 numerous ways to no avail. Help
Have formula: =DATETOTEXT(DATE(year,month,day),format*number) filled in that =; =DATETOTEXT(DATE(2011,1,1),3) or
printed in spreadsheet as = Sat, Jan 01, 2011
I have tried adding +1 numerous ways to no avail. Help