Thread: calculating payment terms "End of Month +30".
View Single Post
  #4   Report Post  
Dorian74 Dorian74 is offline
Junior Member
  
Posts: 10
Thumbs up
Quote:
Originally Posted by Spencer101 View Post
Hi,

Assuming you're using at least Excel 2007 and your date is in cell A2 you can use =EOMONTH(A2,0)+30

Obviously, change the A2 for whichever cell your date is really in.
Hi Spencer,

Thank you very much!
you solved my problem
Reply With QuoteReply With Quote