Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel query using DATES?
I am using DATEVALUE to find the number of days between two dates and then multiplying that number by a daily interest amount. The first date is fixed and I have converted that to a DATEVALUE in H48. The second date is the current date (which increases each day!).
So my formula at present is =DATEVALUE("1 July2011")-H48)*1.136986 where I have to update today's date manually. Is there someway I can substitute TODAY so that it will update automatically?
Laurence. Just want it so that when the spreadsheet is opened each day it will automatically calculate using current date.
I thought =TODAY() gives the current date and thought that you could convert that to a number using DATEVALUE to calculate the elapsed days. There must be a way of counting elapsed days!!
Tony, yes I did try that but it didn't like it! I am sure it should work somehow-will try it again
3 Answers
- Laurence ILv 710 years ago
DATEVALUE and NOW are compatible. TODAY is just a DATE not a DATE/Time
but if you mean can you sit there watching it ticking then no you cant
you would need to write a program to TOUCH some cell to make stuff re-calculate
or use the F9 feature
- TonyLv 510 years ago
Have you tried entering your fixed date in a cell, and add the =TODAY() formula into another cell, and then simply put the calculation in a 3rd cell? e.g. =(A1-A2)*1.136986
The equation returns the number of days between the dates, so that should work fine.
