Forum Discussion
DEOL48
Dec 02, 2023Copper Contributor
Excel Formula for 45 days end of month
Hi , Can anyone tell me excel formula for 45 days end of month…
HansVogelaar
Dec 02, 2023MVP
With an invoice date in D2, enter the following formula in for example E2:
=EOMONTH(D2, 0)+45
Format the cell with the formula as a date.