Date based on data in another cell

Microsoft Excel 2000/visual basic for ap...
August 14, 2009 at 10:51:10
Specs: Windows XP
need a formula to calculate payment dates based on selection in another field example if A1=3, then date should be=DATE(YEAR(H36),MONTH(H36)+1,DAY(H36))
if A1=4 then date should be =DATE(YEAR(H36),MONTH(H36)+2,DAY(H36))
if A1=5 then =DATE(YEAR(H36),MONTH(H36)+3,DAY(H36))

See More: Date based on data in another cell

Report •


#1
August 14, 2009 at 12:03:19
=DATE(YEAR(H36),MONTH(H36)+(A1-2),DAY(H36))

MIKE

http://www.skeptic.com/


Report •

#2
August 14, 2009 at 12:53:02
you are a genius. I had tunnel vision on this.

Thanks again,

Pipper


Report •

#3
August 14, 2009 at 17:21:10
Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question