Home › Forums › Bike Forum › Excel Date Question

Overview Chat Bike Members News Women
Viewing 4 posts - 1 through 4 (of 4 total)
  • Excel Date Question
  • damo2576
    Free Member

    Hi,

    I have some dates in some cells, I need a formula to find the preceeding monday.

    For example if in a cell I had 03/05/11 (today) I need a formula that will output 02/05/11 (the last Monday preceeding).

    Any ideas?

    Posted 13 years ago
    TheFlyingOx
    Full Member

    =[cell_reference]-(WEEKDAY([cell_reference],3))

    Posted 13 years ago
    Stoner
    Free Member

    =A1-((WEEKDAY(A1,2))-1)

    EDIT: too slow. 😉 And I concede, “,3” is neater, but I like Monday=1 😛

    Posted 13 years ago
    damo2576
    Free Member

    Thanks!

    Posted 13 years ago
Viewing 4 posts - 1 through 4 (of 4 total)

The topic ‘Excel Date Question’ is closed to new replies.

Overview Chat Bike Members News Women