Thread: [Solved] Calculate date from two variable fields, with no #value error in empty rows
View Single Post
 
Old 09-20-2023, 10:19 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
On Fly:

Code:
=IF(ISNUMBER($K2), DATE(YEAR($K2), MONTH($K2)+12, DAY($K2)), IF(ISNUMBER($I2), DATE(YEAR($I2), MONTH($I2)+12, DAY($I2)),""))
Reply With Quote