Thread: What would Excel Assume if DATE left blank
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default What would Excel Assume if DATE left blank
Blank is nothing..........but sero is 1/1/1904 in the 1904 date system.

Vaya con Dios,
Chuck, CABGx3



"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