Results 1 to 2 of 2
  1. #1

    Member Since
    Dec 21, 2010
    Help with spreadsheet.
    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

  2. #2

    bobtomay's Avatar
    Member Since
    Dec 22, 2006
    Texas, where else?
    15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '14 1.8 i7 8GB 10.11; 21" iMac '13 2.9 i5 8GB 10.11; 6S
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to use spreadsheet in mac?
    By michelleyang in forum Switcher Hangout
    Replies: 7
    Last Post: 07-13-2015, 02:10 PM
  2. Spreadsheet off-line?
    By peterbj7 in forum iOS and Apps
    Replies: 16
    Last Post: 08-15-2013, 10:44 PM
  3. Is there a spreadsheet that will.................
    By royalpei in forum Switcher Hangout
    Replies: 6
    Last Post: 09-29-2012, 10:24 AM
  4. Spreadsheet
    By Only child in forum macOS - Apps and Games
    Replies: 9
    Last Post: 05-17-2011, 09:31 PM
  5. Spreadsheet with MS Office
    By Angela2307 in forum macOS - Apps and Games
    Replies: 3
    Last Post: 08-16-2009, 05:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts