LinkBack URL
About LinkBacks
if the equipment date is in A1
Formula:
=DATEDIF(A1,TODAY(),"d")
if the equipment date is in A1
Formula:=DATEDIF(A1,TODAY(),"d")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I am using Excel 2007 and it does not have =dateif formula.
That's DATEDIF and it's available in Excel 2007.Originally Posted by gill123
It won't be listed in the Insert Function userform.
You have to manually type it in.
See this:
http://www.cpearson.com/Excel/datedif.aspx
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks