Thread: What would Excel Assume if DATE left blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default What would Excel Assume if DATE left blank
blank is blank, but zero is Saturday, January 00, 1900

--
Gary''s Student - gsnu200765


"Neon520" wrote:

I doing some date calculation, it seems like Excel assume some date when I
left the cell blank, anyone know what does Excel assume when the cell left
blank for the date?
Reply With QuoteReply With Quote