| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I subtract todays date from range of dates
I need to make todays date as a constant so when I drag the formula down the
cells used in calculating the cell with todays date does not change. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I subtract todays date from range of dates
Use =TODAY()
USe absolute references as in =$A$1 We could help better if we saw you formula best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AHD3" wrote in message ... I need to make todays date as a constant so when I drag the formula down the cells used in calculating the cell with todays date does not change. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I subtract todays date from range of dates
Control semi-colon if you don't want it to change on subsequent days;
=TODAY() if you do. -- David Biddulph "AHD3" wrote in message ... I need to make todays date as a constant so when I drag the formula down the cells used in calculating the cell with todays date does not change. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a formula that will subtract todays date from a hire date | Excel Worksheet Functions | |||
| Comparing Dates with todays date | Excel Discussion (Misc queries) | |||
| Subtract one year from todays date | Excel Discussion (Misc queries) | |||
| Number of days between 2 dates, if end date is blank assume todays | New Users to Excel | |||
| Check column of dates against todays date | Excel Worksheet Functions | |||
Linear Mode
