Not sure where to put this... so apologies beforehand.
Okay, so I need to make a formula to enter a date in Excel. I need to start from January 1, 2011 and make a formula that will extend that to January 1, 2021. How do I enter this in? In my notes it says to put in the date, and then the rest should be like this:
=(cell above)+1, (cell above), (cell above)
Advances by year only: Month, day is the same, only the year increases by 1.
But it just comes up with an error message. Help?
Also, how do I make a line and graph chart with excel?
Thank you so much for helping, rep and cookies for those that help me out!
Okay, so I need to make a formula to enter a date in Excel. I need to start from January 1, 2011 and make a formula that will extend that to January 1, 2021. How do I enter this in? In my notes it says to put in the date, and then the rest should be like this:
=(cell above)+1, (cell above), (cell above)
Advances by year only: Month, day is the same, only the year increases by 1.
But it just comes up with an error message. Help?
Also, how do I make a line and graph chart with excel?
Thank you so much for helping, rep and cookies for those that help me out!
Last edited:
