Excel Date Formula

[Steve]

Can I write a formula to check a cell reference to see if
the date it contains is more than 120 days before today?

 

[Frank Kabel]

Hi
try
=IF(A1<TODAY()-120,"more than 120 before today","within 120 days")
if A1 is the cell to check

 

[Harald Staff]

=A1<(TODAY()-120)

 

[spiderhobbit]

Hi,

I thought you all seem like excel gurus so i would like to ask you
question. What i want to do is for my discount cell to produce a £1 o
a £0 depending on the application date in cell 'C' (which is displaye
as 01/10/2004 etc) using an IF formula. I really appreciate your help.

Thanks,

Jack

 

[Frank Kabel]

Hi
maybe something like
=IF(C1<DATE(2004,2,1),0,1)
and format this cell as currency (will give you a discount if you have
applied prior to Feb-01-2004

 

[spiderhobbit]

Hi,

Thanks for your help, but it doesnt seem to work, ive attatched th
file, so if you didnt mind could you see if you can figure out how t
do it please . Btw the formula sheet is the one that i need i
applied to.

Thanks again,

Jack

Attachment filename: it.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47949

 

[Frank Kabel]

Hi
enter the following formula in J8
=IF(F8<=$K$2,$K$5,0)
and copy down

 

[spiderhobbit]

You are a true legend cheers mate