Date problem

Guest · Jun 6, 2007

i have the following function =DATE(YEAR(F5),MONTH(F5)+3,DAY(F5)) but if F5
is blank to display nothing, any sugestions

JE McGimpsey · Jun 6, 2007

One way:

=IF(F5="","", DATE(YEAR(F5),MONTH(F5)+3,DAY(F5))

IF formula not working	6	Mar 31, 2010
date + 6 months	3	Feb 13, 2008
Adding cells but leaving blank if not populated	1	Nov 5, 2009
Display result depending on value entered	3	Jan 6, 2010
dates	2	Feb 13, 2008
copy and paste function	7	May 26, 2008
conditional formatting help required.	2	Mar 11, 2008
Can be here some changes for a faster speed ?	3	Jul 30, 2008

Ask a Question