Question

How are dates interpreted in Excel?​

Answer 1

$\huge\underline{\overline{\mid{\bold{\red{ɪᴛᴢᴍøøɴʙøʏ-}}\mid}}}$

ᴡʜᴇɴ ʏᴏᴜ ʟᴏᴏᴋ ᴀᴛ ᴀ ᴅᴀᴛᴇ ɪɴ ᴇxᴄᴇʟ ɪᴛ's ᴀᴄᴛᴜᴀʟʟʏ ᴀ ʀᴇɢᴜʟᴀʀ ɴᴜᴍʙᴇʀ ᴛʜᴀᴛ ʜᴀs ʙᴇᴇɴ ғᴏʀᴍᴀᴛᴛᴇᴅ ᴛᴏ ʟᴏᴏᴋ ʟɪᴋᴇ ᴀ ᴅᴀᴛᴇ. ɪғ ʏᴏᴜ ᴄʜᴀɴɢᴇ ᴛʜᴇ ᴄᴇʟʟ ғᴏʀᴍᴀᴛ ᴛᴏ 'ɢᴇɴᴇʀᴀʟ' ʏᴏᴜ'ʟʟ sᴇᴇ ᴛʜᴇ ᴜɴᴅᴇʀʟʏɪɴɢ ᴅᴀᴛᴇ sᴇʀɪᴀʟ ɴᴜᴍʙᴇʀ. ᴛʜᴇ ɪɴᴛᴇɢᴇʀ ᴘᴏʀᴛɪᴏɴ ᴏғ ᴛʜᴇ ᴅᴀᴛᴇ sᴇʀɪᴀʟ ɴᴜᴍʙᴇʀ ʀᴇᴘʀᴇsᴇɴᴛs ᴛʜᴇ ᴅᴀʏ, ᴀɴᴅ ᴛʜᴇ ᴅᴇᴄɪᴍᴀʟ ᴘᴏʀᴛɪᴏɴ ɪs ᴛʜᴇ ᴛɪᴍᴇ.

Answer 2

When you look at a date in Excel it's actually a regular number that has been formatted to look like a date. If you change the cell format to 'General' you'll see the underlying date serial number. The integer portion of the date serial number represents the day, and the decimal portion is the time.

hope it will help you........ ❤️