Previous Topic Next Topic

SharePoint/Excel

Closed
tinkwilds Posts 2 Registration date Wednesday June 26, 2013 Status Member Last seen July 1, 2013 - Jun 26, 2013 at 05:27 PM
 LynxDeuxJynx - Jul 2, 2013 at 12:31 AM
Hello,

I am trying to create an If function where the Date field must = 2013. I have that

=YEAR([column 1])=2013

But when the field is null it it still sends the error so I tried this:

=IF([column 1] <>"",TRUE, TRUE)

Which works for when it is null, and allows it to pass... but when I try to combine them It's not working. Can you tell me the correct formula for SharePoint 2010 to require users to input a 2013 date and allow it to be null. I've tried this but it doesn't work...

=IF(YEAR[column 1]=2013, IF(column 1] <>"", TRUE, TRUE)

Does anyone have the solution?
Related:

2 responses

Answer 1 / 2
LynxDeuxJynx
Jul 1, 2013 at 05:25 AM
IF(OR(YEAR[column 1]=2013, IF(column 1] <>""), TRUE, FALSE)
0
Answer 2 / 2
tinkwilds Posts 2 Registration date Wednesday June 26, 2013 Status Member Last seen July 1, 2013
Jul 1, 2013 at 03:47 PM
This doesn't work. It says this formula is not supported...

I'd like validation for a column. The validation should say, the year must be 2013 but only if the field is not null
0
LynxDeuxJynx
Jul 2, 2013 at 12:31 AM
Two questions:

1. Is it the entire column or just cell A1 that has to be validated?
2. What does the actual formula look like with the actual ranges inserted?

A test example (with ranges) would help solving your query.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response