Excel Formula

[strikeuk]

Need some help with this using excel. For example this is the data that I have

Date 28/12/2007

I can get the week using the weeknum formula. This is what I get 52. Now assuming I want to get the date of the first day for this week which is the 24th of December 2007 using formula, how do I go about it? Thanks for the help.

 

[VoG]

Try

=A1-MOD(A1-2,7)

 

[Richard Schollar]

Hi

=A1-WEEKDAY(A1,3)

 

[barry houdini]

=A1-MOD(A1-2,7)

I'd always favour the WEEKDAY option because you get the same result whether using 1900 or 1904 date systems.

The above (MOD) formula will return a Sunday, rather than a Monday, if you are using 1904 date system

 

[VoG]

=A1-MOD(A1-2,7)

I'd always favour the WEEKDAY option because you get the same result whether using 1900 or 1904 date systems.

The above (MOD) formula will return a Sunday, rather than a Monday, if you are using 1904 date system

Thanks Barry - I hadn't thought of that

 

[strikeuk]

Thanks very much for the help guys!