Calculating day differences between two cells
For example:
On cell A1 01/01/2011
On cell B1 01/04/2011
On cell C1 it should display "Less" if day difference is less than 90 days otherwise it should display "More"
Thanks in Advance!
| Attachment | Size |
|---|---|
| Book1.xlsx | 9.44 KB |
How about :- =B1-A1
How about :-
=B1-A1
it worked.
=IF(B1-A1<=90,"LESS","MORE")
and it worked.thank you AndyLitch.