Hi All,
i'm trying to use one formula in my workbook with below criteria but i get some difficulties in this, anyone can help me out would be appreciated
assuming cell A1 is today, and i want C1 return date+1 / date+2 / date+3 if date in A1 is monday / tuesday / friday respectively.
last but not least, i will use this formula in VBA likely: Selection.AutoFill Destination:=Range("C1:C" & Range("A" & Rows.Count).End(xlUp).Row) finally.
my answer in this example in C1 should be 22 march, 2022
thank you very much
i'm trying to use one formula in my workbook with below criteria but i get some difficulties in this, anyone can help me out would be appreciated
assuming cell A1 is today, and i want C1 return date+1 / date+2 / date+3 if date in A1 is monday / tuesday / friday respectively.
last but not least, i will use this formula in VBA likely: Selection.AutoFill Destination:=Range("C1:C" & Range("A" & Rows.Count).End(xlUp).Row) finally.
my answer in this example in C1 should be 22 march, 2022
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 21 March, 2022 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | A1 | =TODAY() |
C1 | C1 | =IF(A1="Monday","a1+1",IF(A1="Tuesday","a1+2",IF(A1="Friday","a1+3",""))) |
thank you very much