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…
2 Replies
- chmloyaltradebdcomCopper ContributorActually i don't have background in IT, learning only from my interest. asking support to choose the lowest plan at the begging.
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.