Related:
- Excel: date+1 year?
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
5 responses
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Jul 28, 2008 at 04:36 PM
Jul 28, 2008 at 04:36 PM
Hi,
Try with this formula where A1 is the cell which contains the date :
Best regards
Try with this formula where A1 is the cell which contains the date :
=IF(TODAY()<EDATE(A1;12);"up to date";"needs updating")
Best regards
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Jul 30, 2008 at 12:01 PM
Jul 30, 2008 at 12:01 PM
Hello,
Did you install all additional macros of excel ?
Did you install all additional macros of excel ?
A few minor syntax errors and I think you will now find this works
=IF(TODAY()>=EDATE(A1,12),"up to date","needs updating")
=IF(TODAY()>=EDATE(A1,12),"up to date","needs updating")
Didn't find the answer you are looking for?
Ask a question