Hi people,
I have a tricky question that I would like some help with please.
Basically, I require a spreadsheet that lets you input 2 dates and then has
some kind of formula that works out if the difference between the two dates
is greater than, equal to or more than 31 days. It seems simple enough but I
am finding it very tricky!

Thanks,
BWT

With the newest date in A1 and the other one in B1:

=IF(A1-B1<31,"Smaller",IF(A1-B1=31,"Equal","Larger"))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BurntWithTime" wrote in message ...
| Hi people,
| I have a tricky question that I would like some help with please.
| Basically, I require a spreadsheet that lets you input 2 dates and then has
| some kind of formula that works out if the difference between the two dates
| is greater than, equal to or more than 31 days. It seems simple enough but I
| am finding it very tricky!
|
| Thanks,
| BWT
|
|

Thank you very much, works great!

"Niek Otten" wrote in message
...
With the newest date in A1 and the other one in B1:

=IF(A1-B1<31,"Smaller",IF(A1-B1=31,"Equal","Larger"))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BurntWithTime" wrote in message
...
| Hi people,
| I have a tricky question that I would like some help with please.
| Basically, I require a spreadsheet that lets you input 2 dates and then
has
| some kind of formula that works out if the difference between the two
dates
| is greater than, equal to or more than 31 days. It seems simple enough
but I
| am finding it very tricky!
|
| Thanks,
| BWT
|
|