DATE

How do I extract the date if the given data are:

1) Week ending date

2) Days of the week (for which the exact date falls into)

 

See example below:

   (a)                                     (b)             (c)

Weekending Mo          Tu          We         Th        Fr             Sa              Su

3 June 2018                                        11hrs     10hrs

10 June 2018                        11hrs

 

So, the data I want to extract with the help of an excel formula is the dates corresponding a, b, and c. If I do it manually, the answers are:

 

a) 30 May 2018 – whcih is the Wednesday on week ending 3 June 2018

b)  2 June 2018 – which is Saturday on week ending 3 June 2018

c) 10 June 2018 – which is Sunday on week ending 10 June 2018

 

Please help! 

By: Sherl

One thought on “DATE

  1. Sherl

    Spacing is not right! Anyway, to clarify the example:

    a) 11 hours falls to Wednesday (We) on week ending 3 June 2018
    b) 10 hours falls to Saturday (Sa) on week ending 3 June 2018
    c) 11 hours falls to Sunday (Su) on week ending 10 June 2018

Leave a Reply

Your email address will not be published. Required fields are marked *