Who is good with formulas in excel? need some help
Page 1 / 1
Does anybody know how to use formulas in excel could use some help.
(Duplicate posts merged - shorTcircuiT)
(Duplicate posts merged - shorTcircuiT)
?,
Hello there, me again LOL! I am NO expert on Excel. I can get by with some very simple rudimentary formulas, but nothing very complicated.
What kind of formulas are you trying to get operational?
Hello there, me again LOL! I am NO expert on Excel. I can get by with some very simple rudimentary formulas, but nothing very complicated.
What kind of formulas are you trying to get operational?
well it involves having the date say mon-sun and have it update automaticlly in another cell so for example todays date is 10/6/2015 through 10/11/2015 so tues-sun and then in another cell called week ending have that cell put a date in and have it populate those other cells to reflect the new week.
Why formulas when you can do it simpler.
Just hammer the starting date in the cell where you want to start and then select the cell. Now drag the dot down or right as far as you want to go & let go of the dot..
You should end up with something like this
You may want to alter the Numerical property of the cell to tell Excell it contains dates or else you might get a few of these in some cells "XXXXXXXX"
Just hammer the starting date in the cell where you want to start and then select the cell. Now drag the dot down or right as far as you want to go & let go of the dot..
You should end up with something like this
You may want to alter the Numerical property of the cell to tell Excell it contains dates or else you might get a few of these in some cells "XXXXXXXX"
Reply
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.