Getting Date result from Date and Whole Number

Hello Everyone,

Can someone lend their expertise? 

I am trying to get a DATE result from a date column [StartDate] and a number column [#ofTerms].

E.g.

[StartDate] 1/17/2024 
[#ofTerms] 12

= 1/17/2025

something like this?

Solved Solved
0 3 69
1 ACCEPTED SOLUTION

Please try 

EOMONTH([StartDate], [#ofTerms]-1)+DAY([StartDate])

EOMONTH() - AppSheet Help

DAY() - AppSheet Help

 

 

View solution in original post

3 REPLIES 3

Please try 

EOMONTH([StartDate], [#ofTerms]-1)+DAY([StartDate])

EOMONTH() - AppSheet Help

DAY() - AppSheet Help

 

 

Thank you! It works. Thank you very much

You are welcome.

Top Labels in this Space