A | B | C |
---|---|---|
1 | Friday, April 15, 2022 | Monday, April 17, 2023 |
2 |
Enter date in B1; Returns date in C1:
Date to be returned, in C1, should be 12 months from date in B1, minus one day; however, if date in C1 falls on a Weekend, then the return date (c1) will be next business day.
*In the example above, the return date in C1 should show Monday, April 17, 2023.