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
- If function with dates - Guide
- Function key stuck on - Guide
- Function of spreadsheet - Guide
- Is not accessible incorrect function - Pen Drive, USB & SD Card Forum
- Wifi function - Guide
1 reply
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
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