Date help

Experts, I am trying to modify my original formula with Now() and if Now() is <Oct 2, 2014 then use 1/1/2015 + 5 days (basically qtr end plus 5 days) but if Now is >10/2/2014 then use the Date(YEAR....stuff
in the below, I dont have an error but I am expecting to get a result of Jan 1, 2015 + 5 days = Jan 6, 2015

What do you see wrong with the below?
=IF(NOW()<10/2/2014,1/1/2015+5,DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)+1,0)+5)

thank you
pdvsaProject financeAsked:
Who is Participating?
 
Raheman M. AbdulConnect With a Mentor Senior Infrastructure Support Analyst & Systems DeveloperCommented:
Use this formula
=IF(NOW()<DATE(2014,10,2),DATE(2015,1,1)+5,DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)+1,0)+5)
0
 
pdvsaProject financeAuthor Commented:
thank you.  I got a little sidetracked.  sorry for the late reply.
0
All Courses

From novice to tech pro — start learning today.