Date Formula

[Rportz]

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.

 

[Fluff]

That was a typo on my part. 12 months from the 15th is the 15th, less one day is the 14th which is a Friday.

 

[Rportz]

That was a typo on my part. 12 months from the 15th is the 15th, less one day is the 14th which is a Friday.

Have you tried the formula? When I enter the date in the blue field, it is returning Sunday, April 16, 2023. I can't figure out why.

 

[Fluff]

If you want 1 year less 1 day use

=WORKDAY(F15-2,1)