Show Calculation on the first of the monthClosed

Question

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



Configuration: Mac OS X Snow Leopard (10.6.8) / Safari 5.1.9

ac3mark · Answer

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~

Show Calculation on the first of the month

1 response

Similar discussions

Subscribe To Our Newsletter!