DATE Formula

[Digital2k]

Hello,
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).
I must add that if today is Thursday I need to know what I will get paid
Thursday through Saturday for the week and from the 29th - 30th of the
month. In
other words for the week and Month calculations 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. If it's the
3rd of the month
I need from the 3rd to the end of the month. What formula
can I use to accomplish this?
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

 

[jseven]

I believe this will work for you.

for today:
=IF(A2=TODAY(),B2,0)

for this week:
=IF(AND(A2>=TODAY(),WEEKDAY(A2)<=7)=TRUE,C2,0)

for this month:
=IF(AND(A2>=TODAY(),MONTH(TODAY())=MONTH(A2))=TRUE,B2,0)

Regards,