Date if function
Closed
Praveen
-
Oct 22, 2016 at 08:40 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 22, 2016 at 09:30 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 22, 2016 at 09:30 AM
Related:
- Date if function
- Mutator function c++ - Guide
- Network card function - Guide
- Hard drive function - Guide
- Find function on mac - Guide
- Excel color function - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 22, 2016 at 09:30 AM
Oct 22, 2016 at 09:30 AM
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
