Help with spreadsheet.

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
 

bobtomay

,
Retired Staff
Joined
Dec 22, 2006
Messages
26,561
Reaction score
677
Points
113
Location
Texas, where else?
Your Mac's Specs
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!
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top