Date if function
Closed
Praveen
-
22 Oct 2016 à 08:40
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Oct 2016 à 09:30
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 22 Oct 2016 à 09:30
Related:
- Date if function
- Hard drive function - Guide
- Network card function - Guide
- Mutator function c++ - Guide
- Vba find function - Guide
- Insert key function - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
22 Oct 2016 à 09:30
22 Oct 2016 à 09:30
Praveen, Good morning.
Try to use:
Show Date Cell -->
=IF(DAY(C2)<=10, DATE(YEAR(C2),MONTH(C2),10), DATE(YEAR(EDATE(C2,1)),MONTH(EDATE(C2,1)),10))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
Show Date Cell -->
=IF(DAY(C2)<=10, DATE(YEAR(C2),MONTH(C2),10), DATE(YEAR(EDATE(C2,1)),MONTH(EDATE(C2,1)),10))
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
