Q
quickquestion
Here is my situation. I have a workbook that needs to have th
following:
1 2 3 4 - 31 Days of the Month
In the cell underneath the days I need it to put the total earned fo
that day. So I need to do an analysis by day for the totals. I wan
to automate this whole process.
Here is what I have so far, but ofcourse it isn't working:
=IF(B38=Q13,F3,"")
B38 is a =DAY(B35)
B35 is a simple =Today()
In my If stament I'm overwriting the old cell value. Yesterday all th
15's were filled out. Now today they are blank while all the 16s ar
filled out. I need to setup and graph this whole process so I need i
to keep yesterdays value in yesterdays cell. Just leave it alone til
next month when date = num.
Thank you for any help
following:
1 2 3 4 - 31 Days of the Month
In the cell underneath the days I need it to put the total earned fo
that day. So I need to do an analysis by day for the totals. I wan
to automate this whole process.
Here is what I have so far, but ofcourse it isn't working:
=IF(B38=Q13,F3,"")
B38 is a =DAY(B35)
B35 is a simple =Today()
In my If stament I'm overwriting the old cell value. Yesterday all th
15's were filled out. Now today they are blank while all the 16s ar
filled out. I need to setup and graph this whole process so I need i
to keep yesterdays value in yesterdays cell. Just leave it alone til
next month when date = num.
Thank you for any help