Prev: Wrap text in cell
Next: How to remove headers when importing from an external source?
From: AHD3 on 10 Mar 2010 14:47
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.


From: Bernard Liengme on 10 Mar 2010 16:06
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" <AHD3(a)discussions.microsoft.com> wrote in message
news:55C115F9-B1D0-430C-B628-B4604D5ABCBC(a)microsoft.com...
> 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.
>
>
From: "David Biddulph" groups [at] on 10 Mar 2010 16:30
Control semi-colon if you don't want it to change on subsequent days;
=TODAY() if you do.
--
David Biddulph


"AHD3" <AHD3(a)discussions.microsoft.com> wrote in message
news:55C115F9-B1D0-430C-B628-B4604D5ABCBC(a)microsoft.com...
> 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.
>
>

 | 
Pages: 1
Prev: Wrap text in cell
Next: How to remove headers when importing from an external source?