• MVP Logo
  • Recent Forum Posts

    jonespandrew

    WEEK Commencing

    Hi Thanks

    Sorry need to explain myself better

    Forumula 1. ="W/C "&TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()-WEEKDAY(TODAY())+1)),"DD/MM/YYYY")...

    jonespandrew Today, 03:00 PM Go to last post
    Hercules1946

    WEEK Commencing

    Like this?

    =IF(D10>C10,"W/C "&TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()-WEEKDAY(TODAY())+2)),"DD/MM/YYYY"),...

    Hercules1946 Today, 02:44 PM Go to last post
    jonespandrew

    WEEK Commencing

    Sunday is the end of the week need it to start from Monday.

    Also trying to do a conditional formate using manual rule entry that says if...

    jonespandrew Today, 02:18 PM Go to last post
    Hercules1946

    WEEK Commencing

    Try this to display the W/C date for this week based on Sunday as the start of the week:

    Code:
    ="W/C "&TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()-WEEKDAY(TODAY())+1)),"DD/MM/YYYY")
    ...

    Hercules1946 Today, 01:52 PM Go to last post
    NBVC

    Numbers present or not present in different ranges (with a twist)

    You can try:

    =IF(SUMPRODUCT(--ISNUMBER(FIND("/"&A1:A18&"/","/"&SUBSTITUTE(A1:A18,", ","/")&"/")))+SUMPRODUCT(--(ISNUMBER(MATCH(A1:A18,Name1,0))))=0,"Miss","-")...

    NBVC Today, 01:51 PM Go to last post