How to perform Current Date calculations

[tuccokeith]

Can you use the current date to create a calculation that can trigger a warning indicator?

If the Current Date > the date in cell A1+15days cell b2 will equal 'Y'

 

[xlhelp]

=if(now()>a1+15, "Y","&quot

 

[desireeg]

Tuccokeith:
Try this formula in cell in b2. You may want to delete the "N" part if you would like the cell to be left blank for false.

=IF(TODAY()>A1+15,"Y","N&quot

Hope this helps!
Desiree

 

[tuccokeith]

Hello,

The calculation works but when a field is blank it is returning a value of "Y"

How can I make sure that a blank field does not generate a "Y" value?

 

[Newposter]

=IF(TODAY()>A1+15,"Y","&quot
Newposter
"Good judgment comes from experience. Experience comes from bad judgment."

 

[xlhelp]

=if(a1="","",if(now()>a1+15, "Y","&quot)