PDA

View Full Version : Solved: Help with formula please



Blackie50
01-19-2010, 04:19 AM
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
01-19-2010, 04:40 AM
Try

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

geekgirlau
01-19-2010, 03:21 PM
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
01-20-2010, 01:27 AM
Thanks for responses - didn't realise it was so simple.