Sachin0612
New Member
- Joined
- Jan 30, 2016
- Messages
- 4
Hello All.
Actually I don't know if it is possible what I am trying to do.
I need a cell to auto update just on a specific date. (E.g. once a month)
If I use "=" the cell but the report will give me value which I have already input and it will give errors cause pay slip has not been issued yet.
that why I want the cell to update on a specific date at the start of each month (1st of each month).
I using it to input travelling fare each date.
01-01-2017 $2
02-01-2017 $2
03-01-2017 $3
01-02-2017 $1
01-02-2017 $3
01-02-2017 $2
01-02-2017 $1
=SUMPRODUCT((MONTH(D:D)=10)*(YEAR(D:D)=2016)*(H:H))
I am using above formula to get the sum for each months.
the totals have to be update on the 1st of each months and it has to coincide with the travelling on the pay slip(Issued at the end of each months)
thanks for your usual support
Best Regards
Sachin
Actually I don't know if it is possible what I am trying to do.
I need a cell to auto update just on a specific date. (E.g. once a month)
If I use "=" the cell but the report will give me value which I have already input and it will give errors cause pay slip has not been issued yet.
that why I want the cell to update on a specific date at the start of each month (1st of each month).
I using it to input travelling fare each date.
01-01-2017 $2
02-01-2017 $2
03-01-2017 $3
01-02-2017 $1
01-02-2017 $3
01-02-2017 $2
01-02-2017 $1
=SUMPRODUCT((MONTH(D:D)=10)*(YEAR(D:D)=2016)*(H:H))
I am using above formula to get the sum for each months.
the totals have to be update on the 1st of each months and it has to coincide with the travelling on the pay slip(Issued at the end of each months)
thanks for your usual support
Best Regards
Sachin