We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Help with Excel formula please

Options
Gers
Gers Posts: 13,137 Forumite
Part of the Furniture 10,000 Posts Photogenic Name Dropper
Hi

Just trying to do a 'new to me' formula which I suspect is an 'IF' one but I am not sure.

I have three worksheets - for ease of use labelled A, B and C.

I want cell B2 in worksheet C to put 28 into it if cell B2 in worksheet B has a date in it. I can then copy it down the remainder of the cells

Is this doable? I'd appreciate some guidance on this please.

Thanks

Comments

  • bod1467
    bod1467 Posts: 15,214 Forumite
    =IF(ISBLANK(B!B2),"",28)

    would be the formula for cell B2 in worksheet C, although this checks whether B2 in worksheet B simply has a value. Unfortunately there isn't an ISDATE function so you'd need to look at nesting IF statements.
  • Gers
    Gers Posts: 13,137 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    HUGE thanks for that - it's worked perfectly.
  • Le_Kirk
    Le_Kirk Posts: 24,511 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    There is no function in Excel that will check for valid dates, just numbers. If you want a true test for valid dates your only recourse is to a vba function (visual basic) unless the answer given above will do you.
  • Gers
    Gers Posts: 13,137 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    Le_Kirk wrote: »
    There is no function in Excel that will check for valid dates, just numbers. If you want a true test for valid dates your only recourse is to a vba function (visual basic) unless the answer given above will do you.

    Thanks - it wasn't for valid (?) dates, just A date is sufficient.

    The formula has worked so I'm a happy bunny!
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.9K Banking & Borrowing
  • 253.1K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.9K Work, Benefits & Business
  • 598.7K Mortgages, Homes & Bills
  • 176.9K Life & Family
  • 257.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.