J
Janet
I have 12 input worksheets - One for every month
I have another 13 worksheets on these, the values from the
1st 12 is broken down to give totals for our 15 locations
and the final is ytd totals for all.
The problem occurs on the YTD sheet. For example,
all the information was input in the January worksheet and
carried forward to the Branch sheet and the YTD sheet as
entered. The balancing of the spreadsheets did not occur
until February 5 and by that time, data had been entered
on the Feb sheet and carried forward to the YTD Sheet.
I tried this on the YTD worksheet but doesn't work
=IF(AND(MONTH(NOW()=2),DAY(NOW()>15)),SUM('Br Jan'!G5+'Br
Feb'!G5))
Thinking that after the 15 of the month it would be fine
because the previous month would have already balanced.
I have another 13 worksheets on these, the values from the
1st 12 is broken down to give totals for our 15 locations
and the final is ytd totals for all.
The problem occurs on the YTD sheet. For example,
all the information was input in the January worksheet and
carried forward to the Branch sheet and the YTD sheet as
entered. The balancing of the spreadsheets did not occur
until February 5 and by that time, data had been entered
on the Feb sheet and carried forward to the YTD Sheet.
I tried this on the YTD worksheet but doesn't work
=IF(AND(MONTH(NOW()=2),DAY(NOW()>15)),SUM('Br Jan'!G5+'Br
Feb'!G5))
Thinking that after the 15 of the month it would be fine
because the previous month would have already balanced.