Help with spreadsheet.

heartman6nmh · heartman6nmh #1 (**permalink**)

12-21-2010, 08:38 PM

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

bobtomay · bobtomay #2 (**permalink**)

12-21-2010, 08:43 PM

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!

heartman6nmh #1 (permalink)
Member Since: Dec 21, 2010 Posts: 1	12-21-2010, 08:38 PM 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),formatnumber) 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 Last edited by heartman6nmh; 12-21-2010 at 08:39 PM. Reason: spelling error*
	QUOTE Thanks

bobtomay #2 (permalink)
Member Since: Dec 22, 2006 Location: Texas, where else? Posts: 21,820 Mac Specs: 15" MBP 2.33 C2D 256 4GB, MBA 13" i7 1.8, MB 2.0 2GB, Nano 4th, 3GS, iPad 1	12-21-2010, 08:43 PM 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. Place your vote for our Member of the Month
	QUOTE Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please suggest a really simple spreadsheet app please?	TGITC	Switcher Hangout	3	10-30-2010 08:34 PM
Emailing a Numbers Spreadsheet	tierney6	OS X - Apps and Games	7	04-10-2009 10:07 PM
Create a mass email from a Numbers spreadsheet	walmartconnect	OS X - Apps and Games	3	07-28-2008 03:49 PM
Appleworks spreadsheet help	Fallooza	OS X - Apps and Games	5	05-04-2006 12:44 PM
Linking Spreadsheet Columns in Appleworks	Mothmom	Running Windows (or anything else) on your Mac	0	12-11-2005 10:43 AM

Help with spreadsheet.

Internet Services

Web Development

Digital Marketing

Consumer Tech

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)