IF STATEMENT - continuing dates

[dunmore83]

Hi,

I would really appreciate some help with the following:

- I have a string of dates in date format 14-Aug-11 in cells B5:AG5

I only want the dates to continute on this ROW if the values in a corresponding cell equal YES. If the value in this cell is NO i would like the cell with the date to return N/A

For example R11 is NO so I want the value in T5 (the date cell) to be "N/A". Otherwise if R11 was YES I want the date in T5 to show & so on.

Any more clarification, please let me know.

THANKS FOR YOUR HELP!!!

Cheers

 

[jbeaucaire]

I got a little lost there in your reference, they seem to have changed. But this is the snippet you need to play with:

(WEEKDAY(Q5)=6)*2

Try adjusting those references to see if you can get your expected results.


The formula I gave you does not do any date formatting, you're seeing the date in the format specified in the cell's formmatting settings.

You can use the Upper and the Text functions to force the display you asked for:

=UPPER(TEXT(A1, "DD-MMM-YY"))

Use that where needed in your formula, adjust the reference. Perhaps that whole formula above goes in place of A1