help req on date

  • Thread starter deepika :excel help
  • Start date
D

deepika :excel help

=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
 
F

FARAZ QURESHI

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
 
D

deepika :excel help

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???
 
D

David Biddulph

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?
 
D

deepika :excel help

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

David Biddulph said:
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 said:
=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
Click to expand...
Click to expand...
 
Top