Make different calculations depending on current month

[cogumelo]

Hi guys,

Can anyone help me out sorting this issue i have?

What i'm trying to is to get a formula that makes a calculation for all the previous months (this year and the previous ones). For the current month (and following months) the cell value will always be "".

I've come up with this but it's not working.

=IF(NOT(MONTH(NOW())&YEAR(NOW()));"make calculation 1";"")

thx in advance

joao

 

[Momentman]

Assuming the date to reference is in cell A1

=IF(A1 < DATE(YEAR(TODAY()),MONTH(TODAY()),1),"Make Calc","")<date(year(today()),month(today()),1),"make calc","")"<date(year(today()),month(today()),1),"make="" calc","")<="" html=""></date(year(today()),month(today()),1),"make>

 

[cogumelo]

hi, thanx for your reply. The problem i'm having is that i'm trying to do it without referencing to any other cell. If the file is open on the current month of the year then there is no calculation to be done.

regards

 

[Momentman]

When you say Open on the current month, I am not sure what you mean? Can it be opened on any other day or month asides the current one?