Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Help with 'Date' function in Excel

FionnK86 · 2015-07-31 08:09:01

Hi guys, I've a small problem with excel, and your help would be appreciated with all my (1) thanks! :rolleyes: :D I have a number of items that need to be renewed every 2 years from their test date on an excel sheet (all dates are different). I need to place a counter beside each entry to show how many days are left until…

31-07-2015 09:09AM

#1
FionnK86

Registered Users, Registered Users 2 Posts: 1,218 ✭✭✭

Join Date: April 2011

Posts: 1074
Hi guys,

I've a small problem with excel, and your help would be appreciated with all my (1) thanks! :rolleyes:

I have a number of items that need to be renewed every 2 years from their test date on an excel sheet (all dates are different). I need to place a counter beside each entry to show how many days are left until they are due.

Preferably, if they are overdue they should highlight on the counter in red and if they are not due they should be in green. Any help?:(

Tagged:

excel

excel 2013

0

Comments

#2 31-07-2015 09:20AM

NeutralHandle

Registered Users, Registered Users 2 Posts: 217 ✭✭

Join Date: July 2015

Posts: 197

TODAY() will get today's date. To get number of days between two dates simply subtract one from the other. Use conditional formatting to highlight them appropriately.

0