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.

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.

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.