Thread: Help with spreadsheet.
12-21-2010, 08:38 PM #1
Help with spreadsheet.
- Member Since
- Dec 21, 2010
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
12-21-2010, 08:43 PM #2
- Member Since
- Dec 22, 2006
- Texas, where else?
- 15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '11 1.8 i7 4GB 10.10; 21" iMac '13 2.9 i5 8GB 10.10; 5s & 5c
I've moved your post to a more proper forum; please be sure to check the forum descriptions in the future to find the best place to post.
By posting in the right forum you help people not only find your question faster, but it helps others looking for the same information in the future.
Thanks for understanding!I cannot be held responsible for the things that come out of my mouth.
In the Windows world, most everything folks don't understand is called a virus.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By michelleyang in forum Switcher HangoutReplies: 7Last Post: 07-13-2015, 02:10 PM
By peterbj7 in forum iOS and AppsReplies: 16Last Post: 08-15-2013, 10:44 PM
By royalpei in forum Switcher HangoutReplies: 6Last Post: 09-29-2012, 10:24 AM
By Only child in forum OS X - Apps and GamesReplies: 9Last Post: 05-17-2011, 09:31 PM
By Angela2307 in forum OS X - Apps and GamesReplies: 3Last Post: 08-16-2009, 05:44 PM