We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
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
Posts: 13,137 Forumite


in Techie Stuff
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
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
0
Comments
-
=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.0 -
HUGE thanks for that - it's worked perfectly.0
-
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.0
-
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!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

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