$$Excel-Macros$$ Re: week update

Hello Saravanan, Its not good idea to use NOW() function as it more specifically used to get time not date and the query is about Date not time. Regards, Sarfaraz Ahmed On Tue, Feb 24, 2009 at 7:16 PM, Saravanan Anna wrote: > Hai, > > Try this > > =NOW()-WEEKDAY(NOW(),1)+2 > > it will help you i

$$Excel-Macros$$ Re: week update

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 wrote: > Hi, > > > Below is the formula- > > > =IF(TEXT(TODAY(),"ddd")="Sun",TODAY()-6,IF(TEXT(TODAY(),"ddd")="Tue",TODAY()-1,IF(TEXT(TODAY(),"ddd")="Wed",TO

$$Excel-Macros$$ Re: week update

i think even the formula below will solve your problem. =TODAY()-WEEKDAY(TODAY(),3) Regards, Sarfaraz Do visit me on MS Excel help On Mon, Feb 23, 2009 at 4:25 PM, Dilip Pandey wrote: > Hi Savio, > > Supposing you have the date in cell A1, type the following

$$Excel-Macros$$ Re: week update

Hi Savio, Supposing you have the date in cell A1, type the following in cell B1. =IF(AND(A1>NOW(),A1 wrote: > > is there any way to have a cell in excel update itself every week to > show the first day of the week? > say the week starts on a monday, the cell displays 23/02/09, retains > this val

$$Excel-Macros$$ Re: week update

Hi Savio, Little update on this. Try following if you want the date to automatically change:- =IF(TEXT(TODAY(),"ddd")="Mon",TODAY(),IF(TEXT(TODAY(),"ddd")="sun",TODAY()-6,IF(TEXT(TODAY(),"ddd")="sat",TODAY()-5,IF(TEXT(TODAY(),"ddd")="Fri",TODAY()-4,IF(TEXT(TODAY(),"ddd")="thu",TODAY()-3,IF(TEXT(

$$Excel-Macros$$ Re: week update

-- 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 Ce

$$Excel-Macros$$ Re: week update

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