Re: how to work out how many days from date to today
Hi,
Im trying to work out how many days if has been from a column with a date in it, please see below example:
Date logged in | days since last logged in
04/03/2010 ! this is where i need the forumla stating how many days its been since the last log in.
Thank you in advance
Try the DATEDIF function.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
If A2 contains Date Last Logged In....eg 4/23/2010 8:00:00 AM
...Assuming A2 contains a date and time
This formula, formatted as a number, returns the number of days since that last log in:
B2: =TODAY()-INT(A2)
Does that help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks