Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Return the date for Independence Day (July 4th) of the current year

Input the formula: =DATE(YEAR(TODAY()),7,4)