sahar_sultana
New Member
- Joined
- Apr 1, 2009
- Messages
- 2
Hi,
A1, B1, C1 and D1 are cell in Excel worksheet and values are 2, 4 and 6 in A1, b1 and c1 respectively.
A1 value is 2
B1 value is 4
C1 values is 6 --C1-Formula is: =sum(A1+B1)
Now I have written formula for D1-cell:
=SUM(C1/(32-DAY(TODAY()+31)-4))
Note: I substracted -4 in above formula because there are four sundays are in April, 2009 and I want to keep days only working days (Total days in April are 30 - sundays which are 4 = 26.)
This spreadsheet will divide c1/26 on Wed April 1, 2009 according to formula.
This spreadsheet will divide c1/25 on Thu April 2, 2009 according to formula.
This spreadsheet will divide c1/24 on Fri April 3, 2009 according to formula.
This spreadsheet will divide c1/23 on Sat April 4, 2009 according to formula.
This spreadsheet will divide c1/22 on Sun April 5, 2009 according to formula.
This spreadsheet will divide c1/21 on Mon April 6, 2009 according to formula.
The problem is in Sunday calculation because Sunday is a Holiday and on Sunday the formula should be same as Sat C/23. On Monday formula should be C1/22 because working day has been started. How can I avoid calculation on date on Sundays and ignore decrease number on sundays. At the end of month on April 30, 2009 the formula should be C1/1.
Please help in this situation/formula and advise about formula for cell-D4. Thanks.
A1, B1, C1 and D1 are cell in Excel worksheet and values are 2, 4 and 6 in A1, b1 and c1 respectively.
A1 value is 2
B1 value is 4
C1 values is 6 --C1-Formula is: =sum(A1+B1)
Now I have written formula for D1-cell:
=SUM(C1/(32-DAY(TODAY()+31)-4))
Note: I substracted -4 in above formula because there are four sundays are in April, 2009 and I want to keep days only working days (Total days in April are 30 - sundays which are 4 = 26.)
This spreadsheet will divide c1/26 on Wed April 1, 2009 according to formula.
This spreadsheet will divide c1/25 on Thu April 2, 2009 according to formula.
This spreadsheet will divide c1/24 on Fri April 3, 2009 according to formula.
This spreadsheet will divide c1/23 on Sat April 4, 2009 according to formula.
This spreadsheet will divide c1/22 on Sun April 5, 2009 according to formula.
This spreadsheet will divide c1/21 on Mon April 6, 2009 according to formula.
The problem is in Sunday calculation because Sunday is a Holiday and on Sunday the formula should be same as Sat C/23. On Monday formula should be C1/22 because working day has been started. How can I avoid calculation on date on Sundays and ignore decrease number on sundays. At the end of month on April 30, 2009 the formula should be C1/1.
Please help in this situation/formula and advise about formula for cell-D4. Thanks.