IF CONDITION ON DATE
Closed
anlene
-
Apr 25, 2010 at 01:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 07:41 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 25, 2010 at 07:41 PM
I am preparing Aging report in which paybles are on 30, 60 ,90 and 120 days. When using the IF condition for all the days . at the end of 120 days it will show in all the coloumn 30,60,90 and 120 as well. When it is 30 days all the 60,90 & 120 are empty this is ok. But what I need is a conditional formula if it is 90 days it should show in 90 days colomn and 30 & 60 days colomn should be empty.Like wise if the data is in 120 days all the rest 30,60 & 90 should be empty.
Related:
- IF CONDITION ON DATE
- Air condition lidl - Home - Apps & Sites
- Add if condition in excel - Guide
- Excel conditional formatting based on date - Guide
- How to disable a cell in excel based on condition ✓ - Excel Forum
- Dear team whatsapp, my whatsapp account is still closed, a lot of my work is on hold due to the account being closed. i have requested you many times, but you are not listening. you are requested to remove the restriction placed on my account. i have been very troubled for a long time. i have read all your terms and conditions carefully and i will not make any mistake in future. please unbanned my whatsapp account which number given below- my mobile number +91xxxxxxxxx - WhatsApp Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 25, 2010 at 07:41 PM
Apr 25, 2010 at 07:41 PM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee. Please have couple of rows of data to show your issue.