IF formula for a date range
Solved/Closed
luxe
-
13 Jan 2021 à 13:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Jan 2021 à 11:57
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Jan 2021 à 11:57
Related:
- If statement with date range
- How to increase wifi range - Guide
- More than 1 if statement excel - Guide
- Excel vba range find - Guide
- Fenix internet on bank statement - Guide
- Vba case statement with string - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
14 Jan 2021 à 11:59
14 Jan 2021 à 11:59
Hi Luxe,
Not sure what you mean by "jan report date". Do you mean an actual date or the text?
Can you show some sample data for better understanding?
As I understand it now, you have for example 4-1-2021 in A2 and 20-1-2021 in B2 (d-m-yyyy). In this case want a "jan report date" as a result.
=TEXT(B2,"mmm") & " report date"
But this can't be what you are looking for, right?
Best regards,
Trowa
Not sure what you mean by "jan report date". Do you mean an actual date or the text?
Can you show some sample data for better understanding?
As I understand it now, you have for example 4-1-2021 in A2 and 20-1-2021 in B2 (d-m-yyyy). In this case want a "jan report date" as a result.
=TEXT(B2,"mmm") & " report date"
But this can't be what you are looking for, right?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
18 Jan 2021 à 11:57
18 Jan 2021 à 11:57
Hi Luxe,
So you want to retrieve the lowest and highest month used in a range.
For low:
=PROPER(TEXT(MIN($A$1:$B$3),"mmmm"))
For high:
=PROPER(TEXT(MAX($A$1:$B$3),"mmmm"))
Best regards,
Trowa
So you want to retrieve the lowest and highest month used in a range.
For low:
=PROPER(TEXT(MIN($A$1:$B$3),"mmmm"))
For high:
=PROPER(TEXT(MAX($A$1:$B$3),"mmmm"))
Best regards,
Trowa
14 Jan 2021 à 13:27
I have a date range. The initial booked date and the the last revised date. I need a formula that reviews these two columns and the date range given up above so that I can determine which month the dates are in. This is for a report for accounting.