Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Excel 365
Date subtraction
Cell A1 and Cell B1 contain dates in dd-mm-yyyy format.
If A1 is greater than B1, result should be 0.
(example: A1 = 31-10-2021 and B1 = 15-09-2021)
If A1 is earlier than B1, result should be in
number of months (part of a month to be
reckoned as a full month)
(example: A1 = 31-10-2021 and B1 = 04-12-2021,
result should be 2. (i.e. 2 months)
Request formula to achieve this.
Date subtraction
Cell A1 and Cell B1 contain dates in dd-mm-yyyy format.
If A1 is greater than B1, result should be 0.
(example: A1 = 31-10-2021 and B1 = 15-09-2021)
If A1 is earlier than B1, result should be in
number of months (part of a month to be
reckoned as a full month)
(example: A1 = 31-10-2021 and B1 = 04-12-2021,
result should be 2. (i.e. 2 months)
Request formula to achieve this.