I hope someone can help me out here. I know which day every week Im going to get paid and I would like to add that amount to a cell every time I get paid automatically. Anybody got this down?
I hope someone can help me out here. I know which day every week Im going to get paid and I would like to add that amount to a cell every time I get paid automatically. Anybody got this down?
Can you attach an example spreadsheet showing how you have things set up and what results you want (e.g. every other Thursday as that day passes, it enters $500)?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Exactly,
I get paid every thursday and I want to add 504.00 to the cell every thursday repeating.
I'm still not sure. Do you want it to sum from the previous row (I assume, you have some sort of calendar set up and column D or whatever is Thursdays?). Do you want it to magically appear only after that date is past or just to the entire calendar? Where are the dates (if you want it to be date dependent) located?
You probably need to define a start date, e.g. assume you want to add that amount every Thursday starting today then put that start date in A1, i.e. 7/7/2009
then in B1 to get $504 added every Thursday
=MAX(INT((WEEKDAY(A1-5)+TODAY()-A1)/7)*504,0)
Thats what i want to do but it doesnt seem to be working when I change the date in A1 to test it out..?
So what date are you trying in A1, what result do you get and what do you want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks