i think even the formula below will solve your problem.
=TODAY()-WEEKDAY(TODAY(),3)
Regards,
Sarfaraz
Do visit me on MS Excel help http://findsarfaraz.blogspot.com/
On Mon, Feb 23, 2009 at 4:25 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Savio,
Supposing you have the date in cell A1,
Hai,
Try this
=NOW()-WEEKDAY(NOW(),1)+2
it will help you i think,
Regards
Saravanan A R
On Sat, Feb 21, 2009 at 8:25 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
Hi,
Below is the formula-
Hi Savio,
Little update on this. Try following if you want the date to automatically
change:-
Hi Savio,
Supposing you have the date in cell A1, type the following in cell B1.
=IF(AND(A1NOW(),A1NOW()+7,TEXT(A1,ddd)=Mon),A1,IF(TEXT(A1,ddd)=sun,A1-6,IF(TEXT(A1,ddd)=sat,A1-5,IF(TEXT(A1,ddd)=Fri,A1-4,IF(TEXT(A1,ddd)=thu,A1-3,IF(TEXT(A1,ddd)=wed,A1-2,IF(TEXT(A1,ddd)=tue,A1-1,A1-0)))
--
Hi,
Here is the solution to your query:
http://www.excelitems.com/2009/02/show-first-day-of-current-week.html
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft
Hi,
Below is the formula-
=IF(TEXT(TODAY(),ddd)=Sun,TODAY()-6,IF(TEXT(TODAY(),ddd)=Tue,TODAY()-1,IF(TEXT(TODAY(),ddd)=Wed,TODAY()-2,IF(TEXT(TODAY(),ddd)=Thu,TODAY()-3,IF(TEXT(TODAY(),ddd)=Fri,TODAY()-4,IF(TEXT(TODAY(),ddd)=Sat,TODAY()-5,TODAY()))
do let me know the feedback
On Sat, Feb