How can I use the "TODAY ()" Function in an "IF/THEN" calculation

R

Rodney

I am trying to create a formula using the "IF" function to calculate monthly
dues on the first of each month. What I've done is set up a worksheet for
each month, and I want the monthly dues to be added to each members account
on the first of each month, but not before. I have tried the following
formula: "If(TODAY()=>4/1/2006,d2+e2,0)". So far, I cant get it to work
correctly.
 
D

daddylonglegs

Excel won't recognise the date in that format, try a small change to
this

=(TODAY()>=DATE(2006,4,1))*(D2+E2)
 
P

Pete_UK

You will have to put the > sign before the = sign. Also, I think you
might have to put the date in as DATEVALUE( ), otherwise it will be
taken as 4 divided by 1 divided by 2006. So, try this:

=IF(TODAY()>=DATEVALUE("4/1/2006"),D2+E2,0)

Hope this helps.

Pete
 
Top