Forum Discussion

DEOL48's avatar
DEOL48
Copper Contributor
Dec 02, 2023

Excel Formula for 45 days end of month

Hi ,

    Can anyone tell me excel formula for 45 days end of month…

2 Replies

  • Actually i don't have background in IT, learning only from my interest. asking support to choose the lowest plan at the begging.
  • DEOL48 

    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.

Resources