Find last Sunday
For the answer as to why +1 is used, I suggest you look in Excel help for
the WEEKDAY function.
The question, of course, remains as to what the OP would have wanted for
"last Sunday" if today is Sunday. He seemed to be including only the
working week as possible inputs, but if he wants a Sunday date to point back
at the previous Sunday, the formula may need to be expanded a little, such
as
=IF(WEEKDAY(A2)=1,A2-7,A2-WEEKDAY(A2)+1)
or, more obscurely,
=A2-1-MOD(WEEKDAY(A2)+5,7)
--
David Biddulph
"Naveed Pathan" wrote in message
...
may i know why 1 is used in the formula plzzzzzzzzzz
"vezerid" wrote:
=TODAY()-WEEKDAY(TODAY())+1
=A2-WEEKDAY(A2)+1
HTH
Kostis Vezerides
|