Thread: How do I subtract todays date from range of dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default 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.


Reply With QuoteReply With Quote