Expert: Richard Rost - 10/28/2009

Question
Hi, what im trying to do is add a set amount to the months.
ie. 31 days in Oct so I want to add $5.00 to every day, so Oct 1st is $5.00, Oct 2 is $10.00, Oct 3rd is $15.00.... i tried by setting out a row from 1-31 representing the number of days in Oct and then having a cell with $5.00 and uses a formula but im having to put in the formual under each date.
Is there an easier way to where i dont have to do this or put in the dollar amount above each date of the month? is there a way to have this calculated automatically on a daily basis with a micro?

Hope you can help, thanks Kelly

Answer
How about putting the actual date in column A, and then in column B you could say:

=DAY(A1)*5

This would give you $5.00 for each day of the month, resetting back to $5 when you hit the first of next month.

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT EXCEL VIDEO TUTORIAL. Go to http://www.599cd.com/Excel/AllExperts


Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Excel Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

I hope this information helps to solve your problem. If there is ANY REASON why you won't give me a RATING of 10 please let me know so I can improve upon my answers in the future. Thank you!

Sign up for my FREE NEWSLETTER with lots of TIPS and TRICKS. Visit http://www.599cd.com/MailingList?key=AllExperts

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts