help req on date
 

=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this

help req on date
 

Why using "+1"?

"deepika :excel help" wrote:

=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this

help req on date
 

Today() is 39504
Adding 1 (I don't understand why?) makes it 39505
Weekday of 39505 is 4
Deducting 4 from 39504 would be 39500
Adding 7 again would result to 39507
Date of which would be 29-Feb-2008
NOT 01-Mar-2008

"deepika :excel help" wrote:

=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this

help req on date
 

i use =TODAY()-WEEKDAY(TODAY(),1)+7 on J2 to get the friday of every week
then in I2 i should need a thursday etc till F2 which is Mon... how do i do
this else???



"FARAZ QURESHI" wrote:

Today() is 39504
Adding 1 (I don't understand why?) makes it 39505
Weekday of 39505 is 4
Deducting 4 from 39504 would be 39500
Adding 7 again would result to 39507
Date of which would be 29-Feb-2008
NOT 01-Mar-2008

"deepika :excel help" wrote:

=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this

help req on date
 

I don't know which part of the world you are in, but here in the UK today is
Tuesday 26th. Adding 1 to TODAY() gets you to a Wednesday. The WEEKDAY
function would return 4 [look at Excel Help for WEEKDAY if you don't know
how it works for the various options]. Your formula therefore starts from
Feb 26th, subtracts 4 and adds 7. In my book that gets you to Feb 29th, not
to March 1st. You did remember that this year is a leap year, didn't you?
--
David Biddulph

"deepika :excel help" wrote in
message ...
=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this

help req on date
 

hey david,
thank you very much.
now is when i realized tah this is a leap year... ha ha thank you again

"David Biddulph" wrote:

I don't know which part of the world you are in, but here in the UK today is
Tuesday 26th. Adding 1 to TODAY() gets you to a Wednesday. The WEEKDAY
function would return 4 [look at Excel Help for WEEKDAY if you don't know
how it works for the various options]. Your formula therefore starts from
Feb 26th, subtracts 4 and adds 7. In my book that gets you to Feb 29th, not
to March 1st. You did remember that this year is a leap year, didn't you?
--
David Biddulph

"deepika :excel help" wrote in
message ...
=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this

help req on date
 

Hi

You don't need the +1
=TODAY()-WEEKDAY(TODAY(),1)+7

--
Regards
Roger Govier

"deepika :excel help" wrote in
message ...
=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this