D
Digital2k
Hello,
I wrote last time:
I want to know what I will get paid TODAY, THIS WEEK or by the
MONTH.
I don't know how to get the Day (C2),Week (D2) and Month.(E2).
Thanks for those who helped.
Now:
I must add that if today is Thursday I need to know what I will get paid
Thursday - Saturday for the week and from the 29th - 30th of the month. In
other words for the week and Month calculations it must be going forward
from the current day not for the entire week or month if that time has past.
If the weekday is Tuesday then I need from Tuesday to Saturday. What formula
can I use to accomplish this? I now I did not make myself clear before. I
apologize.
Please help.
Digital2k
A B C D E F
1 Dates Amount Today This This
Week Month
2 6/27/06 $500 0 $700 $700
3 6/28/06 $200 $200 $700 $700
4 7/1/06 $600 0 0 $700
_________________________________
5 Total $1300 $200 $700 $700
I wrote last time:
I want to know what I will get paid TODAY, THIS WEEK or by the
MONTH.
I don't know how to get the Day (C2),Week (D2) and Month.(E2).
Thanks for those who helped.
Now:
I must add that if today is Thursday I need to know what I will get paid
Thursday - Saturday for the week and from the 29th - 30th of the month. In
other words for the week and Month calculations it must be going forward
from the current day not for the entire week or month if that time has past.
If the weekday is Tuesday then I need from Tuesday to Saturday. What formula
can I use to accomplish this? I now I did not make myself clear before. I
apologize.
Please help.
Digital2k
A B C D E F
1 Dates Amount Today This This
Week Month
2 6/27/06 $500 0 $700 $700
3 6/28/06 $200 $200 $700 $700
4 7/1/06 $600 0 0 $700
_________________________________
5 Total $1300 $200 $700 $700