IF function using dates
Solved/Closed
Escalation
Posts
3
Registration date
Friday February 28, 2014
Status
Member
Last seen
February 28, 2014
-
Feb 28, 2014 at 07:00 AM
Escalation Posts 3 Registration date Friday February 28, 2014 Status Member Last seen February 28, 2014 - Feb 28, 2014 at 09:09 AM
Escalation Posts 3 Registration date Friday February 28, 2014 Status Member Last seen February 28, 2014 - Feb 28, 2014 at 09:09 AM
Related:
- IF function using dates
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Hard drive function - Guide
- Agp function - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 28, 2014 at 07:44 AM
Feb 28, 2014 at 07:44 AM
Escalation, Good morning
Try to use this:
F13 --> =IF(DAY(B13)<=15,B13-15,B13)
Attention: Use the proper separator in your excel version: Comma or semi-colon
Is it what you want?
I hope it helps.
Try to use this:
F13 --> =IF(DAY(B13)<=15,B13-15,B13)
Attention: Use the proper separator in your excel version: Comma or semi-colon
Is it what you want?
I hope it helps.
Feb 28, 2014 at 09:09 AM