Excel Date Formula

  • Thread starter Thread starter Steve
  • Start date Start date
S

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?
 
Hi
try
=IF(A1<TODAY()-120,"more than 120 before today","within 120 days")
if A1 is the cell to check
 
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
 
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
 
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
 
Hi
enter the following formula in J8
=IF(F8<=$K$2,$K$5,0)
and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spurious Formula Omits Adjacent Cells 2
Searching the formula (not the value) for a text string 1
Formula for Dates and CF Colour then convert to Text 3
Excel Average dates help 0
I need Help with a date calculator 0
countifs Function not giving desired result with date criteria 2
Spurious Formula Omits Adjacent Cells 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Back
Top