Dear friends,
I have to generate a table of data with dates, and return if is over 3 months from today ie. today is 07 JAN 2022, if data is in APR 2022 then return the date, if data is MAY 2022 and beyond, and return "renewed".
I had input formula =IF(C3>EOMONTH(TODAY(),3),"Renewed",B3), but all data return "renewed"
Pls help.
Thanks
AC
I have to generate a table of data with dates, and return if is over 3 months from today ie. today is 07 JAN 2022, if data is in APR 2022 then return the date, if data is MAY 2022 and beyond, and return "renewed".
I had input formula =IF(C3>EOMONTH(TODAY(),3),"Renewed",B3), but all data return "renewed"
Pls help.
Thanks
AC
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | New Date | Used Date | Warranty Date | Status | ||
2 | 2022.06.06 | 0000.00.00 | 2022.06.06 | Renewed | ||
3 | 2022.05.01 | 0000.00.00 | 2022.05.01 | Renewed | ||
4 | 2021.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
5 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
6 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
7 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
8 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
9 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
10 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
11 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
12 | 2020.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
13 | 2018.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
14 | 2018.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
15 | 2018.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
16 | 2018.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
17 | 2018.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
18 | 2017.04.30 | 2022.04.30 | 2022.04.30 | Renewed | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2:C3 | C2 | =IF(B2="0000.00.00",A2,B2) |
D2:D18 | D2 | =IF(C2>EOMONTH(TODAY(),3),"Renewed",B2) |
C4:C18 | C4 | =IF(B4="0000.00.00",TEXT(A4,"YYYY.MM.DD"),TEXT(B4,"YYYY.MM.DD")) |