Date Diff in excel 2010
Solved/Closed
Related:
- Date Diff in excel 2010
- Spellnumber in rupees in excel 2010 - Forum - Office Software
- Microsoft excel 2010 free download full version with product key - Download
- Convert number to spelling ✓ - Forum - Office Software
- Excel 2010/VB- Loop until no result is found - How-To - Download software
- How to take screenshot in excel 2010 - Guide
2 replies
TrowaD
Feb 14, 2011 at 09:24 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Feb 14, 2011 at 09:24 AM
Hi Mark,
Try this:
=TODAY()-MAX(B2:J2)
This will tell you the amount of days between todays date and the maximum value of the dates entered (meaning the most recent date entered).
You can now use conditional format to change the way the locations name looks like, depending on the difference in days, to make it easy to spot those locations.
Best regards,
Trowa
Try this:
=TODAY()-MAX(B2:J2)
This will tell you the amount of days between todays date and the maximum value of the dates entered (meaning the most recent date entered).
You can now use conditional format to change the way the locations name looks like, depending on the difference in days, to make it easy to spot those locations.
Best regards,
Trowa