IF statement to add 15 days to A1 if B1=yes

Microsoft Excel 2003 (full product)
December 21, 2010 at 16:20:59
Specs: Windows XP
I have a worksheet where i have a date in A1 and B1 is a yes or no answer. I require an IF statement that basically says if B1 says yes C1 will produce a date 19 days from the date in A1.

See More: IF statement to add 15 days to A1 if B1=yes

Report •

#1
December 21, 2010 at 16:53:25
In C1 use this:
=IF(B1="yes";A1+19;"")

You have to format C1 with the correct date format.

The original poster should always write the last response !!!
Let us know, if the problem is solved !!!


Report •

#2
December 21, 2010 at 17:05:29
That worked great cheers. I had to substitute commas for semi colons so it read =IF(B1="yes",A1+19,"")

thanks a lot for that.


Report •

#3
December 21, 2010 at 17:11:12
Might be, that the german version, I am using, differs in using semicolon instead of comma.

You're welcome.

The original poster should always write the last response !!!
Let us know, if the problem is solved !!!


Report •
Related Solutions


Ask Question