Help with formula please

[Blackie50]

Hi,

Is it possible to create a 'logical test' (or similar) formula to compare 2 cells with dates - the test is that if cell 2 date is more than 30 days in advance of cell 1 date then the result is YES (and if not NO).

Any help appreciated

thanks

Jon

[Bob Phillips]

Try


=IF(A2>A1+30,"YES","NO")

[geekgirlau]

Dates in Excel are really simple. Days are seen as a whole number, while times are decimal values. So as xld has shown above, to work out the number of days between any 2 dates it's simply Date1 minus Date2.

[Blackie50]

Thanks for responses - didn't realise it was so simple.