working with dates

[MORT1703]

Hi

I am working on a problem whereby I have the following columns

A1 - a frequency of MON-SUN
B2 - a date ie 02/06/2015

C1 - needs to contain the date based on A1

IE.

A1 B1 C1
FRI 02/06/2015 NEED TO RETURN 29/05/2015
THU 02/06/2015 NEED TO RETURN 28/05/2015

can anyone help?

[teylyn]

Hello,

this is not clear. Please post a workbook. Click the Go Advanced button and then the paper clip icon to attach your Excel file.

What is the logic? "based on A1"? It contains a week day. So, how do you get from the name of a weekday to the date?

[sktneer]

Assuming A1 contains Fri (Text), then try this......

In C1

Please Login or Register  to view this content.

Is this what you are trying to achieve?

[MORT1703]

as requested

[MORT1703]

exactly what I needed
thanks

[sktneer]

Glad to help.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.