Hey guys,
I've a spreadsheet here in Excel 2010 which I'm populating with a table outputted from another program. One of the columns in it will be a list of dates (in american format though!). What I need is a function which looks at this date and returns the difference between this and the current date in days (rounded to whole number is fine)
Is it the DATE360 function I need for this?
Cheers!
Manolis
Hi Manolis( Are you Greek?)
You can use simple this(With your date in A1)
=A1-TODAY()
Format, as General.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
look @
= DATEDIF ( start_date , end_date , unit )
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
maybe use: =today()-A1
A1 your date
or
=ROUND(today()-A1,0)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Hi Fotis!
I'm half Greek! Born in Kavala and lived on Thassos for my first couple of years but have been in Ireland since. I'll be going over again in September hopefully!
I like your comments about the politicians!
Unfortunatly all the functions suggested are returning a #VALUE error.
Is this Excel not recognising my date from the pasted-in table as the functions seem to make sense?
Μανώλη(Manolis), Must be some format problem in your data.
All suggested formulae must work for you!
Upload a small sample workbook to take a look there.
*So, we'll wait you back to Greece in September..
Practice Sheet.xlsx
Here you go.
It's definately the format issue as a few of them do work. But these are being read as European date format
Manolis, is real strange.....I can not understand what happens...
I'll keeping looking for a while...
Hope, someone else to have a good idea about this........
Hi select columns with dates and usy text to columns click 2 times "next" then choose date and set this on MDY and "Finish"
Thanks Tom,
That what it was!
And thanks to everyone else too!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks