Calculating Dates

[Erika]

I want to be able to enter a date in a cell for example
12/01/2004 and in cells that run down the page I want the
result to look at the date enter and calculate the
following 11/01/2004, 10/01/2004, 09/01/2004

Anyone know of a way to set this formula up?

 

[JulieD]

Hi Erika

if i'm understanding you correctly type your date in cell A1 (for example)
then in A2 type
=A1-1
and fill down (move cursor over bottom right of cell until you see a +, hold
down the left mouse & drag)

Cheers
JulieD

 

[Frank Kabel]

Hi
in A2 put the formula
=A1-1
and copy this down

 

[Govind]

Hi,

You can enter the value in say cell A1

Then in A2 enter =date(year(A1),month(A1),day(A1)-1)

and copy it down to cells A3,A4 etc.

Regards

Govind.

 

[Guest]

As a result of that formula the first date I get
11/30/2004 and as I copy that result down I get
11/29/2004, 11/28/2004 and so on. I just want the month
to subtract one so I get 11/01/2004, 10/01/2004

 

[JulieD]

Hi

sorry, i think i must be on the other side of the world to you, where we use
the date format of
dd/mm/yy not mm/dd/yy like you (apparently) do.

one formula that might work for you is
=DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))

Cheers
JulieD

 

[Frank Kabel]

Hi
we probaby all assumed your date was formated DD/MM/YYYY and not
MM/DD/YYYY

So use the following formula:
=DATE(YEAR(A1),MONTH(A1)-1,MIN(DAY(A1),DAY(DATE(YEAR(A1),MONTH(A1),0)))
)

 

[Domenic]

A2, copied down:

=DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))

Hope this helps!

 

[Guest]

You have me going in the right direction all I did was
change the formula you gave me to

=date(year(A1),month(A1)-1,day(A1))

and it did the trick! Thank you so much!!!

 

[Govind]

Thanks for the feedback.

I wasnt aware of your date format so thought you want a date to be deducted.


Regards

Govind