Help Needed : To find Monday date in a week

**Elangovan89** · 03-19-2014, 08:26 AM

Hi All,

I will extract data from a particular webpage in any day of the week.This sheet is contains the date and time of the when data was extracted(in A1).

Ex: If extracted date is 03/13/14 i need to apply formula to replace the current date to Monday date of that particular week.

In Simple,

Actual date : 03/13/14
Replace with : 03/10/14(-90 days)

I really appreciate your help!!!

Regards
Elango

**daffodil11** · 03-19-2014, 08:31 AM

=if(weekday(a1,2)<>1,a1-(weekday(a1,2)-1),a1)

**Kaper** · 03-19-2014, 08:32 AM

http://www.excelforum.com/search.php returns for instance:
http://www.excelforum.com/excel-form...same-week.html
and there is an answer for you.

**Elangovan89** · 03-19-2014, 01:48 PM

Hi Daffodil11,

Thank you so much!!! It was simply superb..

Regards
Elango

**Elangovan89** · 03-19-2014, 01:51 PM

Hi Kaper,

Thanks for the link. The given formula is very simple i'm gonna use that.

I also have a question on this. Why are we using 2 =A3+2-WEEKDAY(A3). How it works?

Elango

Help Needed : To find Monday date in a week

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Help Needed : To find Monday date in a week

Re: Help Needed : To find Monday date in a week

Re: Help Needed : To find Monday date in a week

Re: Help Needed : To find Monday date in a week

Re: Help Needed : To find Monday date in a week

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to find monday and friday in a recent whole week

VBA to insert this first monday of the week date function/value

[SOLVED] Find monday preceeding given-date unless date is a monday

Finding the Monday date based on a different date in same week

date of monday of each week automatically

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions