Show Calculation on the first of the month

Closed
bluemoonintn - Jun 23, 2016 at 02:20 PM
 Blocked Profile - Jun 23, 2016 at 06:23 PM
Hello,

I have created a spreadsheet with various calculations. I have it divided as monthly items, however, I prefer that a certain calculation only happen on the first day of each month and remains blank until the 1st? Here is my calculation I would like to happen on the 1st of July. I would prefer it stay blank until July 1.

=D53+(G26+G28+G29)-(G3+G4+G5+G6+G7+G8+G11+G12+G13+G14+G32+G34+G35+G36+G37+G38+G39+G40+G41+G42+G43+G44+G45+G46+G47+G48+G49+G50+G51+G52)

Thanks,
David



1 reply

Blocked Profile
Jun 23, 2016 at 06:23 PM
Try this:
Set up a formula in cell D1, that says =now()

Now in another cell, put this:
=IF(D1>="7/01/2016",D53+(G26+G28+G29)-(G3+G4+G5+G6+G7+G8+G11+G12+G13+G14+G32+G34+G35+G36+G37+G38+G39+G40+G41+G42+G43+G44+G45+G46+G47+G48+G49+G50+G51+G52) ,"")

Give that a try. Every day you load that sheet, D1 will change dates!

Low tech solution! But you get the idea~
0