IF functions with dates
Solved/Closed
kev8687
Posts
2
Registration date
Thursday 24 September 2015
Status
Member
Last seen
24 September 2015
-
24 Sep 2015 à 00:59
kev8687 Posts 2 Registration date Thursday 24 September 2015 Status Member Last seen 24 September 2015 - 24 Sep 2015 à 02:27
kev8687 Posts 2 Registration date Thursday 24 September 2015 Status Member Last seen 24 September 2015 - 24 Sep 2015 à 02:27
Related:
- IF functions with dates
- Apple iphone 13 release dates - Guide
- If function with dates - Guide
- Annual mileage calculator with odometer dates ✓ - Excel Forum
- Different dates of "end to end encryption message" on blank chat? - Excel Forum
- Mwc barcelona dates - Guide
1 response
kev8687
Posts
2
Registration date
Thursday 24 September 2015
Status
Member
Last seen
24 September 2015
24 Sep 2015 à 02:27
24 Sep 2015 à 02:27
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.