I need a numeric value for today's date minus july 1, 2013 so that every day I open the excel sheet, this value will be updated based on today's date. Is this possible to do in excel?
thanks!
I need a numeric value for today's date minus july 1, 2013 so that every day I open the excel sheet, this value will be updated based on today's date. Is this possible to do in excel?
thanks!
Last edited by Ocean Zhang; 08-07-2013 at 01:51 PM.
Try =Today() to get today's date.
Check out Excel's "Date and Time" function for more options
hi Ocean. as mike mentioned, use TODAY. additionally, here's what you can input:
=TODAY()-"1Jul2013"
or:
=TODAY()-DATE(2013,7,1)
or refer to a cell where 1Jul2013 is:
=TODAY()-A1
format cells to General
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks