IF functions with dates
Solved/Closed
kev8687
Posts
2
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015
-
Sep 24, 2015 at 12:59 AM
kev8687 Posts 2 Registration date Thursday September 24, 2015 Status Member Last seen September 24, 2015 - Sep 24, 2015 at 02:27 AM
kev8687 Posts 2 Registration date Thursday September 24, 2015 Status Member Last seen September 24, 2015 - Sep 24, 2015 at 02:27 AM
Related:
- IF functions with dates
- Functions of spreadsheet - Guide
- When you wrote incorrect functions, what did you learn about spreadsheet data? ✓ - Excel Forum
- If statement with dates - Guide
- Multiple functions in one cell - Excel Forum
- Functions of wifi - Guide
1 reply
kev8687
Posts
2
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015
Sep 24, 2015 at 02:27 AM
Sep 24, 2015 at 02:27 AM
I received a reply on another forum informing me that 42270 is how excel sees the date as a number. I formatted the cell to show the date and it worked.