ExcelBanter - If statement + date calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If statement + date calculation (https://www.excelbanter.com/excel-programming/382832-if-statement-date-calculation.html)

DP7

If statement + date calculation

Hi I am not quiet sure how to write this IF statement. If AC= €œmon€ then
add 8 days to ab, but if AC = €œthur€ the add 6 days to ab.
Thanks

JE McGimpsey

If statement + date calculation

One way:

=IF(AC1="mon",AB1+8,IF(AC1="thur",AB1+6,""))

In article ,
DP7 wrote:

Hi I am not quiet sure how to write this IF statement. If AC= €œmon€ then
add 8 days to ab, but if AC = €œthur€ the add 6 days to ab.
Thanks

All times are GMT +1. The time now is 12:23 AM.