I'm a new member to this E- Forum, and happy to be here.
I would like to know the formula which generate number of days passed for a list of items as per today:
e.g sales of 12/03/2013
Stock of 20/4/2013
how many days from each date as per today date.
thanks
A1= your start day.
=DATEDIF(A1,TODAY(),"D")
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
thanks, I will try it.
Hi
this formular will calculate the number of days between today and the date value in cell A1, is that what you need?
=TODAY()-A1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks