| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Todays date
Hi All
I have a spreadsheet with a date field. I want to calculate how many days have passed since that date. So I need to minus todays date from the original date. Does anyone know how I get Excel to display todays date and update for each new day. Any help greatly appreciated Kind regards Rexmann |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Todays date
Rexmann,
=TODAY() -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "rexmann" wrote in message ... Hi All I have a spreadsheet with a date field. I want to calculate how many days have passed since that date. So I need to minus todays date from the original date. Does anyone know how I get Excel to display todays date and update for each new day. Any help greatly appreciated Kind regards Rexmann |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Todays date
=TODAY()-A1
where A1 holds that date. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "rexmann" wrote in message ... Hi All I have a spreadsheet with a date field. I want to calculate how many days have passed since that date. So I need to minus todays date from the original date. Does anyone know how I get Excel to display todays date and update for each new day. Any help greatly appreciated Kind regards Rexmann |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Todays date
=today()
-- Kind regards, Niek Otten "rexmann" wrote in message ... Hi All I have a spreadsheet with a date field. I want to calculate how many days have passed since that date. So I need to minus todays date from the original date. Does anyone know how I get Excel to display todays date and update for each new day. Any help greatly appreciated Kind regards Rexmann |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Todays date
=NOW()
Type this into the cell you want to represent today's date and format to date format required Pete -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "rexmann" wrote in message ... Hi All I have a spreadsheet with a date field. I want to calculate how many days have passed since that date. So I need to minus todays date from the original date. Does anyone know how I get Excel to display todays date and update for each new day. Any help greatly appreciated Kind regards Rexmann |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Todays date
=today()
"rexmann" wrote: Hi All I have a spreadsheet with a date field. I want to calculate how many days have passed since that date. So I need to minus todays date from the original date. Does anyone know how I get Excel to display todays date and update for each new day. Any help greatly appreciated Kind regards Rexmann |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| How to put todays date in one cell then the next cell adds x days | Excel Discussion (Misc queries) | |||
| Changing today's date to the first of the month | Excel Worksheet Functions | |||
| how to use today's date in a equation to caculate somebody's birth | Excel Discussion (Misc queries) | |||
| Setting today's date automatically in Excel. | Excel Worksheet Functions | |||
Linear Mode
