New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Help with spreadsheet.


Post Reply New Thread Subscribe

 
Thread Tools
heartman6nmh

 
Member Since: Dec 21, 2010
Posts: 1
heartman6nmh is on a distinguished road

heartman6nmh is offline
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
QUOTE Thanks
bobtomay

 
bobtomay's Avatar
 
Member Since: Dec 22, 2006
Location: Texas, where else?
Posts: 25,021
bobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond reputebobtomay has a reputation beyond repute
Mac Specs: 15" MBP 2.33 C2D 256 4GB, MBA 13" i7 1.8, MB 2.0 2GB, Nano 4th, 3GS, iPad 1

bobtomay is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Have been scratching my head .... | Problems archiving Mac Mail »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

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

All times are GMT -4. The time now is 10:37 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?